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...
Monthly Archive: August 2009
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
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
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?
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
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
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
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
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?
Yes it is! See this blog post from Peter Saddow: SQL Server on Windows 7 First, if you have User Access Control in full swing, UAC will generate a prompt to make sure you're...
SQL Server 2008 R2 : A quick experiment in Unicode Compression
Fellow MVP Simon Sabin mentioned today 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, but...
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
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
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...