Yearly Archive: 2011

Connect Digest : 2011-12-20

Make SSMS start faster A couple of years ago, I blogged about some ways to make Management Studio start faster. With the latest builds of SQL Server 2012, it seems to be slower than...

Connect Digest : 2011-12-01

Where is my graphical ShowPlan? Many of you on SQL Server 2008 R2 are experiencing a major annoyance with SSMS since installing service pack 1 – when clicking a plan from grid results, you...

'CLR Enabled' is not required to use CLR built-ins

Books Online articles referencing built-in CLR functions (such as FORMAT()) have a remark similar to the following: FORMAT relies on the presence of .the .NET Framework Common Language Runtime (CLR). A lot of people...

Determining distribution of NULL values

Today on the twitter hash tag #sqlhelp, @leenux_tux asked: How can I figure out the percentage of fields that don't have data ? After further clarification, it turns out he is after what proportion...

A birthday, of sorts…

A year ago today, I made quite easily the best decision of my career, and joined the folks at SQL Sentry. I explained a lot of this process in a blog post last year,...

SQL Sentry Plan Explorer v1.3

On Friday, we published a new version of our free query plan analysis tool, SQL Sentry Plan Explorer. We've added a couple of important features: SQL Server 2012 support With a whole slew of...

A rose by any other name…

At the PASS Summit, one of the most anticipated announcements was the release date, and marketing label, for SQL Server code-named "Denali" – the release date is "first half of 2012" (which probably means...