Is It that Time Again?

Yes, it is.  As I mentioned a few months back, it is important to pay attention to when Microsoft releases...

COMPUTE: now it is going, what else will do it?

/*I'd be very surprised if you've ever used the old COMPUTE clause in SQL Server. It is a bit mad,...

PASS Elections – Improving the Process

Since there has been a bit of a furor over the PASS election process the past 2 years I thought...

Common SQL Server Mistakes – Multi Row DML Triggers

How often have you seen someone write a DML trigger like this:
createtrigger mytrigger on Mytable forinsertas

declare @id int
select @id = id...

Microsoft Releases SQL Server 2008 SP1 Cumulative Update 10

On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29...

Braindumps and Certification

I saw a post recently that said that braindumps were the best way to prepare for certifications. It was posted...

Why You Should Come to SQL Saturday #48 - Columbia, SC

SQL Saturday #48 is on October 2. We're offering free SQL Server and PowerShell training from some great names in...

Range locks do not only occur in Serializable transactions....

According to BOL, "Key-range locks protect a range of rows implicitly included in a record set being read by a...

Updates on SQLSaturday#59 in NYC

Hi, ALL:  Just want to bring you some updates and news on SQLSaturday#59 @MS HQ in NYC on Nov 20, 2010. ...

Index Black Ops Part 3 – Index Usage

Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...