Monthly Archive: November 2011

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