#sql-server-2005

Locking in SQL Server and the nolock and readpast hints

I’ve written about transactions, the TransactionScope in .NET before. System.Transact...

Sep 13, 2011

Wouldn’t you like to be able to use the Query Analyzer again? I couldn’t count the nu...

Mar 7, 2008

The weekendafter has passed and I’ve slept through most of it. Man did we use up som...

Sep 17, 2007

Wow it’s been some time since I blogged. Mainly because of being very busy at work an...

Aug 3, 2007

UPDATE It seems the SQL team actually have build a solution. A while ago I wrote s...

Jun 28, 2007

This might come in handy for some of you, as it did for me. I normally don’t have pro...

Feb 28, 2007

Download code & sql scripts here I got a question today about setting the isolationle...

Dec 18, 2006

SQL Server 2005 problem solved. The ISO’s I used were probably corrupted. I installed...

Nov 23, 2006

Via Steve Eichert I came across an article about database security. It’s based on sec...

Nov 21, 2006

So I’m still running Vista and guess what… I got my first BSOD this morning! I can’t ...

Nov 21, 2006

For the first time in my life I’m playing around with the new SQL Server 2005 .NET CL...

Nov 8, 2006