SQL Server Diaries

In previous posts I described techniques how to extract TRIGGER and DEFAULT constraint definitions using T-SQL scripting.  Today I will explain how I used database system objects to generate CREATE INDEX statements for my database. [Read More]

It has been in the SQL Server Books Online since the 2000 version was published, and a considerable number of articles have been written against the use of the “sp_” stored procedure naming convention. What I cannot understand is why newly written stored procedures are being pushed for deployment using... [Read More]

A few posts ago I published a Script to generate Trigger definitions. This week’s topic covers another automation script to generate scripts, this time related to DEFAULT Constraints.  Simplistically put, whenever a DEFAULT constraint is definied on a table column, if the column is set to disallow NULL values and... [Read More]

Once your databases are live and your production SQL Server instance is functioning to it’s best, a user might decide to transfer large amounts of data into a database using SSIS, BCP, or some other custom application.  When such data transfers occur SQL Server logs activity in the transaction log. ... [Read More]

This must have happened to most DBAs: you’re working on the usual stuff, monitoring your SQL Server instances, trying to keep everything oiled and running smoothly when you receive a phone call from a developer who tells you about some new module that has to be implemented soon.  You schedule... [Read More]