Connect Works

Uncategorized
Microsoft Connect works. I've said it before and I'll say it again, but it really does work. You will get the attention of MS developers and they will respond. It's not always fast, but it gets there. Of course, I was trying to create samples for the book, which came out almost two weeks ago, so this is a bit late for me personally... HA! But it really does work.
Read More

Execution Plan Estimated Operator Cost

Uncategorized
I've said it over and over again, the costs on operators in execution plans, even in actual execution plans are estimates.  You need to understand that when looking at your execution plans. It's vital because you need to be able to distinguish between the truly costly parts of a plan and the less costly parts of a plan. Don't believe me? Take a look at this picture and see if you can spot the discrepancy: Spot it yet? Add up the costs for the operators visible in the part of the plan... Yep 125%.  And there's more to the plan that I'm not showing. I think this one must total near 200%. The statistics are up to date and there's no consistency errors in the database. These estimates are just off sometimes.…
Read More

Technical Editor

Uncategorized
Joseph Sack was the technical editor for my book. He also happens to be a great guy. I learned a lot from him as we went through the book. Where I didn't learn from him, he kept me focused, always pointing out where I was slipping off the 2008 track. Whatever worth the book holds, a lot of it comes from him. Oh, and he writes, all on his own. So it's not like he needs me at all.
Read More

It’s a book!

Uncategorized
I just received my copies of the book. "SQL Server 2008 Query Performance Tuning Distilled" is an honest to gosh, in print, available on Amazon and Barnes & Noble BOOK! Sorry, just need a little time for a victory dance on the table. Huzzah!
Read More

SQL Server 2008 Management and Administration

Uncategorized
I just got a book in the mail from a friend, Todd Robinson, who was the technical editor. The name of the book is Microsoft SQL Server 2008 Management and Administration. The book was written by Ross Mistry and Hilary Cotter. I don't know Ross Mistry and I think I met Hilary Cotter once, although I know who he is. However, since Todd was involved, I'm pretty sure this is going to be a high-end, must read. I just started and the initial chapter's discussion on using Windows Server 2008 sparked a few questions for my local admin team. I'm looking forward to more. Thanks Todd.
Read More

Apress Alpha Program

Uncategorized
Apress has a new program called Alpha where they make available books in progress. You can download, for a price, an e-copy of some of the chapters of the book for early review. It allows you to get in on the action a bit and you can post comments to the author to influence the final work. My new book, SQL Server 2008 Query Performance Tuning Distilled, just got added to the Alpha program. They have 10 of the 16 chapters posted. Additionally, they've got a publication date set for March. I've only seen the production copy of three of the chapters and I'm on the second draft of chapter 16, so I think that seems tight, but they're the pros.
Read More

2008 Index Fragmentation

Uncategorized
I forgot all about this, but a script I wrote on using all the new functionality of dynamic management views & functions to do index defragmentation and rebuilds got published over at SQL Server Central. It could stand a bit of tweaking, but gets the job done on several of the systems I've tested it on so far.
Read More