(Don Schlichting) In this second article, the use of Distributed Partitioned Views for Insert, Update, and Delete statements will be explored.
Tag: sql server
Performance Tuning and Optimizing ASP.NET Applications
While SQL Server often gets the blame for poor performance, more often than not, it is the application that is really causing the problem. And this is also true for ASP.NET applications that use SQL Server as its back-end database. While this website has a little coverage on how to performance tune
CAST and CONVERT
Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality.
FIX: SQL Server 2000 may not start if many users try to log in to SQL Server when SQL Server is trying to start
If many users try to log in when SQL Server 2000 is trying to start, SQL Server 2000 may not start. You may also see error messages that are similar to the following in the SQL Server error log: 2003-12-16 13:58:01.11 spid5 Clearing tempdb database. 2003-12-16 13:58:01.11 spid5 Could not creat
Microsoft Tech·Ed 2004
Don’t miss Microsoft’s most comprehensive technical event for IT professionals and developers! Tech·Ed 2004 provides a unique opportunity to participate in customized educational programs, get hands-on training from industry and Microsoft experts, and preview the newest technology. Throw in the spec
Inside the SQL Server 2000 User Mode Scheduler
(Ken Henderson) Up through version 6.5, SQL Server™ used the scheduling facilities in Windows® to schedule worker threads, switch between threads, and generally handle the work of multitasking. This worked reasonably well and allowed SQL Server to leverage the hard-learned lessons regarding Windows
Best Practices Analyzer
(Michael Otey) If you’re a new SQL Server administrator or a part-time DBA who isn’t familiar with SQL Server, you’ll find Microsoft’s new administration tool, the SQL Server 2000 Best Practices Analyzer, invaluable. The product is available for download at http://www.microsoft.com/downloads/details
Working with the Registry
(Dinesh Asanka) I was looking for a function which will return me the country list. I found that list if countries in the registry. List of the countries resides in the SOFTWAREMicrosoftWindowsCurrentVersionTelephonyCountry List. Therefore My task was reduced to read this registry. But unfort
SQL Server Yukon: Advantages of the new PIVOT operators
(Sanders Kaufman, Jr.) Database developers who use Microsoft products have often experienced frustration at the disparity of functions between Access and SQL Server. SQL Server, which uses Transact-SQL (T-SQL), is a step behind Access in its range of features, although it is several steps ahead in t
Web Data Administration Tool from Microsoft
(Gregory A. Larsen) Are you a Database Administrator that has a desire to work remotely but don’t have access to your databases while you are out of your office? Would you consider using a web interface to manage your SQL Server databases and Logins? If so, then you might want to consider checking o
