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