(Suhil Srinivas) This article explains the various steps involved in writing and executing a Yukon CLR Procedure. This article also is a starting point to develop complex data crunching SQL procedures.

DBCC Commands or Database Consistency Checker commands have been with SQL Server from its early ages itself. In this article we would list the available DBCC commands listed using the DBCC Help command. Many in this list are undocumented and are rarely used in practical scenarios. But these form th

(Graz) This article covers the basic of transactions. It describes them and gives examples of committing and rolling back transactions. It also shows how to properly trap errors inside a stored procedure using transactions.

This article provides a reference for some of the most common issues you can encounter when installing and using SQL Server replication. This article is not a replacement for the SQL Server documentation. All of the concepts, terms, and topics below are documented in the SQL Server “Administrator’s

(Brian Moran) IT professionals are inundated with information that isn’t useful for getting their jobs done. Most vendors, including Microsoft, produce in-depth technical information about how things work but fail to produce material that ties all the pieces together. That’s why best practices docum

(Goce Smilevski) Alexander Kozak described an efficient row-based solution for the problem of identifying islands and gaps in sequential numbers in his article, Islands and Gaps in Sequential Numbers. The set-based solutions described there were not very efficient, especially when the input data was

(William Pearson) In our last tutorial, Control Location of Processing, we began a three-part mini-series, Optimizing MDX. We stated that the objective of this “triptych” is to explore methods for optimizing the performance we obtain from our MDX queries. We introduced types of intervention, or clas

(Steve Callan) So far, the trigger-happy DBA series has dealt with triggers related to Data Manipulation Language (DML) operations. As mentioned in the beginning of the series, another type of useful trigger is that of the system trigger. System triggers can be delineated into two categories: those

This script can be run when you want to do batch processing on a database, such as a dynamic truncate statement for all tables in your database. This script will actually script all the Foreign Keys in your database, and then store them into a table called FOREIGN_KEY_TEMP. It will then generate,

(Mia Shopis) This weekend marks the one-year anniversary of the SQL Slammer worm outbreak that brought down critical applications and services, including ATMs, emergency services, networks and even some airline services. Slammer broke shortly after midnight Jan. 25, 2003, exploiting a security flaw