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 DAC?"  It was a great question, and my initial response was that, most likely, the schema […]

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 models.  And I also plan to put Unicode compression through more tests, and will file any […]

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, and I bet you're thinking, "I'll believe it when I see it." If you can get […]

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 suggest that compression can bring significant CPU overhead, and can as much as double the amount […]

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 yada.  To me, at this early point in the release cycle, these features are, well, boring […]

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 troublesome formats for date literals.  Initially the Books Online topics mentioned in the item used "1/10/1900" […]

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) says that only certain versions of SSMS are affected, and proceeds to list build numbers that […]

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 Update #15 for SP2 brings you up to 9.00.3330 (the previous update was 9.00.3328). http://support.microsoft.com/kb/972510

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 out at your leisure, and if you agree or disagree with the assessment, vote! Blue-on-blue ugliness […]

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 Server making changes to your computer: If you're not okay with this, obviously, click No, and […]

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 a couple that have increased in size.  You might think that I determined this by loading […]