I would like to share some interesting parameters I found for the undocumented extended stored procedure xp_ReadErrorLog. In doing some testing with this extended stored procedure I found four very...

ApexSQL Giving Away 25 Copies of Enforce

ApexSQL is launching a new product called Enforce.  As part of their launch they are giving away twenty-five copies to our members for participating in the forums.  Read on for the details and to f...

Joining to the Next Sequential Row

One of the more obscure requirements that a developer may find themselves facing is the need to compare a row with its immediate sibling. One such case is when a list of values needs to be processe...

Using the TIME data type in SQL Server 2008

SQL Server 2008 introduces a TIME data type which allows us to store the time without the date.

Implementing Table Inheritance in SQL Server

When designing a database, we sometimes come across situations where there are multiple types of entities that we are modeling, but we'd like them to all have certain attributes or relations in com...