Getting graphical ShowPlans back in SQL Server 2008 R2

For those of you using the SQL Server 2008 R2 version of Management Studio, and have applied Service Pack 1, you have probably noticed that clicking on a ShowPlan in grid results no longer shows the graphical plan, but rather opens a new window with the raw XML. For example, […]

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, "Moving on up… but not to the East Side." I knew then several reasons I thought […]

SQL Sentry Plan Explorer v1.3

On Friday, we published a new version of our free query plan analysis tool, SQL Sentry Plan Explorer. As noted in the change list, we've added a couple of important features. SQL Server 2012 support With a whole slew of changes to the showplan schema in Denali, we've added operators […]

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 somewhere around June 25th), and the official name is SQL Server 2012. The logo was revealed […]

Unexpected errors from table-valued functions

I've seen a few people stymied by this one recently, even though @PaulRandal wrote a mythbuster article about it last April. (If you don't want a spoiler alert, don't click through just yet.) They want to use a dynamic management function with parameters, for example: SELECT * FROM sys.dm_db_index_physical_stats ( […]

Finding keyless tables across multiple servers

Christina Leo (@christinaleo) asked this question on twitter today: So, if I ever needed a POSH script, today is the day. Having to inventory all prod databases to find tables missing primary keys. I have a query that returns what I need, but I need a report for each of […]

What do BETWEEN and the devil have in common?

I'll make no bones about it: BETWEEN is evil. For one, the meaning of the word in English does not always match the meaning of the operator in T-SQL. In T-SQL, BETWEEN is an *inclusive* range – not everyone gets that. Sure, in casual conversation when someone says "between 3 […]

Cumulative Updates for SQL Server 2008 R2 are available!

Today Microsoft has released Cumulative Updates for SQL Server 2008 R2. Cumulative Update #10 for SQL Server 2008 R2 RTM Build number: 10.50.1807 KB article: KB #2591746 13 fixes Cumulative Update #3 for SQL Server 2008 R2 Service Pack 1 Build number: 10.50.2789 KB article: KB #2591748 22 fixes Please […]

Blogging from the PASS Summit Keynote : Day 3

This is a rough morning. Got in at 2:00 AM, then had no water in my hotel this morning. I doubt I will ever voluntarily stay at the Seattle Hilton again. Still, I'm very much looking forward to this keynote – the illustrious Dr. David DeWitt is going to make […]

Blogging from the PASS Summit Keynote : Day 2

VP Finance, Bill Graziano comes on stage in a great kilt (but white socks!). No Tina Turner this year. 1,000 people from 53 countries watched the keynote yesterday. He recognizes Tim Radney (@tradney) and Jack Corbett (@unclebiguns) for their outstanding volunteer work over the past year, and then congratulates Lori […]