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.
October 8, 2008 1:12 AM
The company I work for just finished our office move into our newer slightly larger office. I've managed to snag myself a Window seat this time around. I just wanted to share the view with everyone. This is the view out my desk window.
October 6, 2008 8:33 AM
Orange County now has its own
October 1, 2008 11:00 AM
With SQL Injection Attacks being all the rage these days, I've been asked a...
September 30, 2008 6:58 PM
This morning I released another tip on SearchSQLServer.com called "SQL Server consolidation: Why...
September 29, 2008 11:00 AM
When dealing with a high load replication environment network latency and network traffic can become as issue. There are a few settings you can play with, within the subscription agents themselves such as the –PacketSize, -UseInprocLoader, and –SubscriptionStreams. While working with these...