(Robin Schumacher) There is perhaps no greater responsibility for the database administrator than establishing proper backup and recovery plans. Although the DBA performs other important tasks, nothing approaches the critical nature of ensuring the protection of key corporate data. For this reas

(Serdar Yegulalp) The total amount of space used to store an individual row of data in SQL Server cannot exceed 8,060 bytes. (R)

(Ken Henderson) The author profiles the User Mode Scheduler (UMS) in SQL Server 2000 that requires developers to write code that runs efficiently, and yields often enough in the appropriate places. UMS provides more control and allows the server to scale better than it could with the Windows schedul

(Barrie Sosinsky) When most people think of the phrase “hardening a server,” they tend to think in terms of security practices that make it difficult for people to gain unintended access to your database. That is only one kind of hardening. From the standpoint of Windows server technology, harde

A database move can be done a couple different ways, but when the database is updated frequently and the move needs to be completed with minimal downtime and no data loss, it is best to move it by detaching and then reattaching the database on the new server.

The following issue is fixed in this Microsoft SQL Server 2000 hotfix package: • When you run a query in Microsoft SQL Server 2000 that has many items in the IN clause, you may receive the following error message: Server: Msg 3628, Level 16, State 1, Line 2 A floating point exception occurre

(Andrew Novick) The current theme is about application trace messages. So far we’ve created AppSession rows to organize a session, AppSessionTrace rows with the trace lines, and AppSessionMeasurement rows to store metrics. At the end of each script that uses the usp_AppSession_* stored procedures

(Itzik Ben-Gan) T-SQL is the core language for server-side data access and manipulation in SQL Server. Applying best practices will help you get the most out of T-SQL. You can use the following checklist to make sure that your T-SQL code is efficient and easy to maintain. (R,$)

(Lisa Vaas) SQL Server 2005 is performing just fine in at least one beta customer’s site, contrary to a recent report that expressed doubt as to the upcoming relational DBMS’ ability to do high-performance computing.

(Dan Farino) xp_pcre is a follow-up to my extended stored procedure xp_regex. Both allow you to use regular expressions in T-SQL on Microsoft SQL Server 2000. This version was written because xp_regex uses the .NET Framework, which many people were reluctant to install on their SQL Servers.