Monthly Archive: October 2011

Getting graphical ShowPlans back in SQL Server 2008 R2

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...

A birthday, of sorts…

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

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...

A rose by any other name…

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...

Unexpected errors from table-valued functions

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...

Finding keyless tables across multiple servers

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...

What do BETWEEN and the devil have in common?

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...

Cumulative Update #1 for SQL Server 2008 SP3 is available!

Cumulative Update #1 for SQL Server 2008 SP3 is available!

The first cumulative update for SQL Server 2008 SP3 is available. Build number: 10.00.5766 KB Article: KB #2617146 19 fixes  Please note: this update is not for SQL Server 2008 R2 or for SQL...

Cumulative Updates for SQL Server 2008 R2 are available!

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...

Blogging from the PASS Summit Keynote : Day 3

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...

Blogging from the PASS Summit Keynote : Day 2

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...

PASS Summit 2011 Resource List : What's New in SQL Server 2012

PASS Summit 2011 Resource List : What's New in SQL Server 2012

At PASS I am giving a presentation on Denali SQL Server 2012 – What's New in Engine and Tools. In previous blog posts I've compiled a list of resources and, now that CTP3 is...

Blogging from the PASS Summit Keynote : Day 1

Blogging from the PASS Summit Keynote : Day 1

Before the lights came down, I had already hit what will probably be the highlight of my morning: having a brief conversation with Dr. David DeWitt. Rushabh Mehta, President, PASS Rushabh Mehta comes on...

Getting Juneau CTP3 to work – SqlCeManager issues

Getting Juneau CTP3 to work – SqlCeManager issues

Since installing Juneau, I've had various issues accomplishing even the simplest of tasks. I would get errors saying that the SqlCeManager could not be initialized or "object reference not set to an instance of...

SQL Server v.Next (Denali) : Changes to Resource Governor

SQL Server v.Next (Denali) : Changes to Resource Governor

After reading the headline, you're probably quite excited – but sadly, no, Denali does not introduce the ability to govern I/O. But there are some cool additions here that you will be able to...

SQL Server 2008 Service Pack 3 is available!

SQL Server 2008 Service Pack 3 is available!

Today Microsoft released Service Pack 3 for SQL Server 2008. The build number is 10.00.5500. The announcement blog post from SQL Server Release Services team: http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/10/06/sql-server-2008-sp3-is-now-available.aspx List of fixes: KB #2546951 : List of...

Printing SPID information along with DBCC output

Printing SPID information along with DBCC output

Today on the #sqlhelp hash tag on twitter, @sqlsponge asked, I am trying to loop through each active spid for dbcc inputbuffer. How can I print spid with inputbuffer output? My response was that...

Where will you find me at the PASS Summit?

Where will you find me at the PASS Summit?

I wanted to lay out my rough schedule at PASS Summit 2011, so you'll know where to find me. And this is as much for me as it is for you – this is...

A handy search procedure

A handy search procedure

I often see questions about searching stored procedures, functions, etc. for specific keywords. Maybe it's an object reference they're looking for, or all of the places where they use built-in functions like GETDATE() (I...

T-SQL Tuesday #23 : Well, that's a kick in the JOIN…

T-SQL Tuesday #23 : Well, that's a kick in the JOIN…

This month's T-SQL Tuesday is a week early due to the upcoming PASS Summit. It is being hosted by Stuart Ainsworth (blog | @codegumbo) and the topic is a general one: JOINs. I had...

Policy-Based Management : Which facets support which evaluation methods?

Policy-Based Management : Which facets support which evaluation methods?

At SQLBits this week, a colleague of Chris Testa-O'Neill (twitter) asked me a question about Policy-Based Management. Specifically, he wanted to know how to determine, programmatically, which execution modes are applicable to each facet...