Thank you Orange County SQL Server Users Group
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 here. If […]
Handy Query to look at amount of data in Buffer Cache
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 […]
Attending PASS 2008? Want a free MCP exam?
Microsoft and PASS have announced that you can take a free Microsoft Certification exam. Visit the PASS Community Summit 2008 Microsoft Learning Certification Center Registration Site for more information. I have just registered for one, so thier appear to still be free registrations available. This program is only available for people who are going to […]
Why is my SELECT COUNT(*) running so slow?
Take a look at the execution plan for your query. You’ll notice that the query is doing an Index Scan (or a table scan), not an Index Seek which is why the SELECT COUNT(*) takes so long. The reason for this is that the COUNT(*) function needs to look at every record in the table. […]