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 ever, at least when starting SSMS for the first time after a reboot or install. So […]

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 Build number is 10.50.2796 Contains 53 fixes (as of February 6, 2012) SQL Server 2008 R2 RTM Cumulative Update #11 […]

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 I would share a couple of productivity tips – so still T-SQL related, but more how […]

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 get raw XML instead of the graphical plan. I wrote about this symptom and a workaround […]

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 KB article is KB #2617148 There are 18 fixes posted to the KB article The new […]

'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 seem to interpret this as meaning: "You must enable the sp_configure option 'CLR enabled' in order […]

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 have selected the Distributed Replay Controller, you should be very careful about choosing the "Add Current […]

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 the DMV and other system changes. Here is what I have noticed: New objects in RC0 […]

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 of columns are NULL. Some folks suggested using a data profiling task in SSIS. There may […]

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 INFORMATION_SCHEMA views – I provided several examples where I feel the INFORMATION_SCHEMA views fall short of […]

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 the system tables like sysindexes from time to time, but I tried to stay away from […]