Yearly Archive: 2011

Connect Digest : 2011-12-20

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

New cumulative updates for SQL Server 2008 R2 are available!

New cumulative updates for SQL Server 2008 R2 are available!

Microsoft has just released cumulative updates for both SQL Server 2008 R2 branches – RTM and Service Pack 1. SQL Server 2008 R2 Service Pack 1 Cumulative Update #4 http://support.microsoft.com/kb/2633146/ Build number is 10.50.2796...

T-SQL Tuesday #25 : T-SQL Tips 'n' Tricks

T-SQL Tuesday #25 : T-SQL Tips 'n' Tricks

This month's T-SQL Tuesday is being hosted by Allen White (@SQLRunr) and is about sharing your T-SQL tips and tricks. Since I know many people will share their T-SQL magic and wizardry, I thought...

Connect Digest : 2011-12-01

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

Cumulative Updates for SQL Server 2008 SP2/SP3 are available

Cumulative Updates for SQL Server 2008 SP2/SP3 are available

Very early this morning, Microsoft released two new cumulative updates for the SQL Server 2008 platform. Cumulative Update #7 for SQL Server 2008 Service Pack 2 If  SELECT @@VERSION  is between 10.00.4000 and 10.00.4322...

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

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

SQL Server 2012 : The Data Tools installer is now available

SQL Server 2012 : The Data Tools installer is now available

Last week when RC0 was released, the updated installer for "Juneau" (SQL Server Data Tools) was not available. Depending on how you tried to get it, you either ended up on a blank search...

SQL Server 2012 : A couple of notes about installing RC0

SQL Server 2012 : A couple of notes about installing RC0

If you're going to install Distributed Replay Controller I've posted about this on twitter a few times, but I thought I should put it down somewhere permanent as well. When you install RC0, and...

SQL Server 2012 : Changes to system objects in RC0

SQL Server 2012 : Changes to system objects in RC0

As with every new major milestone, one of the first things I do is check out what has changed under the covers. Since RC0 was released yesterday, I've been poking around at some of...

Determining distribution of NULL values

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

T-SQL Tuesday #24 : Dude, where's the rest of my procedure?

T-SQL Tuesday #24 : Dude, where's the rest of my procedure?

This month's T-SQL Tuesday is being hosted by Brad Schulz (blog) and the topic is one that should attract a lot of submissions: Procedures and Functions. Last week, I talked about the case against...

The case against INFORMATION_SCHEMA views

The case against INFORMATION_SCHEMA views

In SQL Server 2000, INFORMATION_SCHEMA was the way I derived all of my metadata information – table names, procedure names, column names and data types, relationships… the list goes on and on. I used...

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