(Don Schlichting) In this second article, the use of Distributed Partitioned Views for Insert, Update, and Delete statements will be explored.

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

Explicitly converts an expression of one data type to another. CAST and CONVERT provide similar functionality.

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

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

(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

(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

(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

(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

(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