Dissecting SQL Server Execution Plans Chapter 3

The third chapter has been published over at Simple Talk. So if you’re interesting the book, you can go to Red Gate to get a free e-book copy of it, or you can see chapters one and two and now three over at Simple-Talk. And for those who just feel the need to kill a […]

Read More

Shrinking Databases

Tim Ford put up a hilarious blog post outlining an instance where shrinking databases is acceptable. I’m pretty sure the development method he describes is well documented and in use in more than one location around the world, including somewhere in my company. Read it.

Read More

SQL Server 2008 Management and Administration

I finally wrote up my review of the book SQL Server 2008 Management and Administration. Todd Robinson, the technical editor, sent me a copy a while back. It’s a good book. I’ve already found it useful several times.  Worth a read. Go pick up a copy.

Read More

Three Kinds of Execution Plans

You read that correctly, three kinds of execution plans. You may have thought that all you had to deal with are estimated and actual, but there is one more. The estimated plan is the plan that comes out of the optimizer. It’s based on statistics and indexes and known objects within the system. The actual […]

Read More

Public Speaking

A great post on the how’s, why’s, etc., of presenting by Paul Randal. I found it because of Database Weekly. Some of the discussion are things I’ve read about in other places with more more or less detail. But please, don’t think I’m knocking it in any way. It’s a unique look at presenting from someone who does q...

Read More

Networking

Andy Warren has just posted the last entry in a very interesting set of posts about building and working your own network. I think they’re all worth a read, especially if you’ve been thinking about blogging, Twitter, LinkedIn or just volunteering at your local users group.

Read More

Refining the Missing Index Data

In my previous post I showed how you could determine if a query had missing index information, but it was difficult to get meaningful data out because I didn’t know XQuery well enough. I spent some more time refining the query and here are the results. This new query will show some basic performance information […]

Read More

Missing Index Information and Query Stats

So the goal was to find a way to pull information from sys.dm_exec_query_stats so that we could identify poor performing procedures that were in cache at the moment and combine it with missing index information from sys.dm_db_missing_index_details. We’re combining these because we’re working with a Microsoft Dynamics CRM database that i...

Read More

PASS Chapter Spotlight

The Southern New England SQL Server Users Group was picked for the February spotlight on the PASS web site. This was largely based on the work we did helping Adam Machanic run the New England Data Camp. I’ve said it before and I’ll say it again, we helped. Adam did 90% of the work. It’s […]

Read More

PASS Editorial Board: Blog Directory

Andy Warren and the PASS Editorial Board have posted their first delivery, a blog directory of SQL Server blogs. That’s as complete a list as you’re likely to see, anywhere, on blogs related to SQL Server. Well done everyone. This is just the beginning of a new and growing set of services from the PASS […]

Read More