July 5, 2011 2:00 PM
Contrary to popular belief WITH (NOLOCK) isn’t actually the SQL Server “Turbo” button. While it may appear that way,...
August 9, 2010 11:00 AM
August 31, 2009 6:26 PM
There seams to be some confusion between what a Primary Key is, and what an Index is and how they are...
February 2, 2009 1:31 PM
SQL Server has two basics kinds of indexes. They are...
October 20, 2008 11:05 AM
I'd like to thank the Orange County SQL Server Users Group for having me come and speak at their meeting last week. I had a great time speaking with everyone, and there were a lot of good questions.
If you didn't have a chance to download the slide deck you can download it
October 16, 2008 11:00 AM
Here's a handy query which I've written which I've used to see how much of each table is loaded into the SQL Server Buffer Cache. It shows you how much data is in memory, how much space is used on disk, and the percentage of data in memory compared to the amount of data on disk.
October 15, 2008 7:07 AM
Microsoft and PASS have announced that you can take a free Microsoft Certification exam. Visit the
October 13, 2008 11:01 AM
Take a look at the execution plan for your query. You'll notice that the query is doing an Index Scan (or a table...
October 10, 2008 8:04 PM
Sean McCown posted what I think is an excellent blog post about Database...
October 10, 2008 11:06 AM
Well today is the one year birthday of my blog. It's been a very fun and exciting year. Here's hoping that the next year will be just as fun.