Monthly Archive: August 2009

SQL Server 2008 R2 : More peeking under the hood

SQL Server 2008 R2 : More peeking under the hood

A little over a week ago, I performed some initial investigation into what has changed between SQL Server 2008 and 2008 R2.  Steve Cooney quickly asked, "Where is all the schema for UCP and...

Connect digest : 2009-08-29

Connect digest : 2009-08-29

I had a pretty busy week, and did not come up with much.  I know, I'm lame.  I have a series of Connect items I'd like to file regarding AutoShrink, DBCC SHRINKDATABASE, and recovery...

Madison is shipping to TAP customers

Madison is shipping to TAP customers

They call it their new, massively scalable data warehousing solution; they say it can load 1TB per hour and support data warehouses in the petabyte range, all on commodity hardware.  Bold claims, for sure,...

SQL Server 2008 R2 : Digging deeper into Unicode compression

SQL Server 2008 R2 : Digging deeper into Unicode compression

When SQL Server 2008 R2 was first released, I wrote a quick blog post discussing the additional space savings gained by Unicode compression. In one of the follow-up comments, Adam Machanic was quick to...

Peeking under the hood : what bits have changed in SQL Server 2008 R2?

Peeking under the hood : what bits have changed in SQL Server 2008 R2?

We know what new features are available in SQL Server 2008 R2: data-tier applications (still with that unfortunate and poorly-chosen acronym, DAC), control point explorer, dashboard viewpoints, report builder 3.0, Unicode compression, StreamInsight, yada...

Connect Digest : 2009-08-22

Connect Digest : 2009-08-22

I rounded up a few interesting items this week. Does "1/10/1900" mean January 10th, or October 1st? This item demonstrates that Microsoft isn't all that concerned about publishing sample code that uses ambiguous or...

How to really detect the version of SSMS you are running

How to really detect the version of SSMS you are running

Earlier this week, a hotfix was released that, among other thigns, addressed an issue where, if you restored a 2000 database from 2005 SSMS, it did not go well.  The KB article (KB #972687)...

New cumulative updates available for SQL Server 2005 SP2/SP3

New cumulative updates available for SQL Server 2005 SP2/SP3

Sleeping at the wheel again, I missed some big updates for SQL Server 2005 this past Monday. Cumulative Update #5 for SP3 brings you up to 9.00.4230 (the previous update was 9.00.4226). http://support.microsoft.com/kb/972511 Cumulative...

Connect digest : 2009-08-14

Connect digest : 2009-08-14

I have a very short window to get this post out, so I apologize if I don't elaborate my justification for pointing out a lot of these issues to you.  Check the feedback items...

Is SQL Server 2008 supported on Windows 7 / Windows Server 2008 R2?

Is SQL Server 2008 supported on Windows 7 / Windows Server 2008 R2?

Yes it is!  See this blog post from Peter Saddow: http://blogs.msdn.com/petersad/archive/2009/08/11/sql-server-on-windows-7.aspx First, if you have User Access Control in full swing, UAC will generate the following prompt to make sure you're okay with SQL...

SQL Server 2008 R2 : A quick experiment in Unicode Compression

SQL Server 2008 R2 : A quick experiment in Unicode Compression

Fellow MVP Simon Sabin blogged today about one of the few engine enhancements we'll be seeing in SQL Server 2008 R2 : Unicode compression. You can read more about the topic in Books Online,...

New / changed columns in SQL Server 2008 R2 DMVs

New / changed columns in SQL Server 2008 R2 DMVs

I was expecting more changes, but as Denis Gobo already pointed out, there is not a single new DMV in SQL Server 2008 R2.  There have been some column additions, however, as well as...

Connect digest : 2009-08-09

Connect digest : 2009-08-09

Sorry, I've been trying to keep this to a regular Saturday installment, but it was a beautiful weekend here and I just couldn't pass up on non-computer-related activities.  I have a short list of...

Whither art thou, oh Microsoft support?

Whither art thou, oh Microsoft support?

UPDATE – 2009-08-07 9:39 PM EDT – the SQL Server Release Services team has published a blog post that reflects largely what I've said below. However, many questions are still unanswered. For example, they...

More on splitting lists : custom delimiters, preventing duplicates, and maintaining order

More on splitting lists : custom delimiters, preventing duplicates, and maintaining order

The other day, I showed you my approach (but not necessarily the best approach for everyone) to splitting a comma-separated list of integers.  Some of the functions I threw up there catered to integers...

Processing a list of integers : my approach

Processing a list of integers : my approach

It is a common problem… you need to pass multiple values into a stored procedure and, as a result, update multiple rows.  Let's pretend we have a table of students: CREATE DATABASE School; GO...

Connect digest : 2009-08-01

Connect digest : 2009-08-01

I had a fairly busy week, so I did not get to spend a lot of time rounding up old, nearly-forgotten Connect items.  But I do believe I came up with at least one...