(Thiru Thangarathinam) With the functionality found in the .NET Framework Base Class Library (BCL), database developers now have access to thousands of pre-built classes and routines which can be easily accessed from stored procedures. The BCL includes classes that provide functionality for improved

(Steve Jones) Performance tuning is something everyone needs to do and should do periodically. I recently started a new job and one of the ways I can get a handle on the SQL Servers I support is to start baselining performance. This series focuses on the methods that I used to setup monitoring and a

(Brian Moran) If you’re running Windows XP Service Pack 2 (SP2) and SQL Server, you’ve probably figured out that the XP SP2 default installation prevents most network access to SQL Server—including to Microsoft SQL Server Desktop Engine (MSDE). Fortunately, making SQL Server and XP SP2 coexist isn’t

(A. Russell Jones) Microsoft’s impending release of the new capability to write stored procedures in SQL Server is a big advance and technologically admirable, but it raises serious questions about whether such a capability is appropriate. In short, do managed stored procedures increase or solve som

The intent of this document is to explore various backup scenario plans for SQL servers and come up with a recommendation to successfully restore them when the need arises. Database Administrators (DBAs) typically spend most of their time working on configuring and monitoring backup plans, but rarel

(Kalen Delaney) One of my favorite SQL Server topics to teach about is the query optimizer, whose job is to determine which query plans SQL Server will use to execute the queries your applications submit for processing. A main optimizer task is to determine which indexes, if any, SQL Server will use

(Marcin Policht) In our previous article, we started our discussion about SQL Server 2000 authorization, focusing initially on permissions assigned to standard fixed server and database roles. We also explained that on the database level, SQL Server 2000 provides more flexibility, since it allows yo

(Baya Pavliashvili) SQL Server 2000 supports three distinct types of replication: snapshot, transactional, and merge, each of which has its own purpose.

(Ryan Randall) A simple task, I thought, but it took me to some interesting places. The method is broadly this: 1) Create an instance of SQL-DMO SQL Server, and use the script method to save the create table text in a file. 2) Get the text from the file into a sp variable. 3) Delete the text fi

(Itzik Ben-Gan) In my May article “Calculating Row Numbers in SQL Server 2005,” I discussed how to calculate row numbers in deterministic scenarios by using the ROW_NUMBER() function, one of four new analytical functions in SQL Server 2005. Here, I’ll complete the discussion about row numbers in