Cape Cod .NET Users Group

September 22, 2009 at 10:26 am (PASS) (, , )

Tomorrow night, Wednesday, September 23, I’m going to present on “Best Practices for Working with SQL Server Execution Plans” for the Cape Cod .NET User’s Group.  It’s basically a rehearsal for the presentation that I’ll be doing at the 2009 PASS Summit in just 5 weeks. Can you believe it’s already almost here? I’m so jazzed. This year is going to be a great summit. I can’t wait to see everyone again… I… Where was I, oh yeah, come down to Hyannis if you can make it. It should be a fun evening. Not quite as good as the Summit, but a good time.

Permalink Leave a Comment

Gila Monster on Estimated vs. Actual Row Counts

September 22, 2009 at 6:47 am (SQL Server 2005, SQL Server 2008, TSQL) (, , , , )

I don’t generally do lots of blog aggregation and cross post linking & stuff. It’s just not something I’m that into. However, this time is an exception. Gail Shaw, Gila Monster to those who hang on out SQL Server Central, has posted an excellent explanation of times when Estimated and Actual row counts vary for a reason. I’m one of those who emphasises that differences between estimated & actual is an indication of… something. It could be out of date or missing statistics or it could be caused by query language like multi-statement table valued functions, but it’s usually and indication of a problem. Except when it’s not. Read Gail’s explanation for more.

Permalink Leave a Comment