I am just taking a quick show of hands; and maybe some information, if you are willing.  (And if this hasn't happened to you, I apologize for taking up your time.) I have had various problems on multiple installations of Books Online throughout the entire Katmai / SQL Server 2008 cycle.  They have been on both 32 and 64-bit; with / ...

Microsoft has publicly stated that SQL Server 2008 will RTM in Q3.  It is Quarter 3 now.  Where is it?  :-) I'm sure that the final touches will now get taken care of now that Bill Gates is no longer a full-time MSFT employee.  I'm sure that his ''short-timer'' attitude trickled down to the develpers working on the product and ...

If you have systems that are stil on SQL Server 2000 and that you are preparing for SQL Server 2005, run the Upgrade Avisor for SQl Server 2008 as well.  So, while you are under the hood of your database and app getting it ready for 2005, get it ready for 2008 too.  There are a lot of new features in 2008, but nothing that was taken away ...

SQL Server's new logo has been published:   Courtesy of Wesley from http://blogs.msdn.com/wesleyb/archive/2008/06/03/sql-server-logo.aspx Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!

After spending the past couple of weeks at the MVP Summit in Seattle and at SQL Connections in Orlando, I thought I should blog about things that do not change in 2008 (at least partially). One of the reason s to partition your tables is to make it more managable.  Although there has been some enhancements in the manner that partitions are ...

No, this is not a ''funny funny, ha ha!'' April Fool's Day post (though I do find those entertaining, and considered posting one myself).  This is for real, and it almost made me tingle a little.  I saw this comment from Eric Kang in a Connect item yesterday morning:''This is a known issue that we have addressed in a release candidate ...

In SQL Server 2008, you can have what is called a ''Filtered Index''.  What does this mean?  An index may be created for a subset of rows in your table.  For instance you could create a filtered index for a ''state'' column if the value is ''CA'' for California; the rest of the states would not have a value.  When you create ...

I am still on the fence about whether this is a good thing or a bad thing.  However, in the next build of SQL Server 2008 you will be able to get your hands on, you will find that some element limits have changed, just a bit.  With the introduction of sparse columns, you can now jam 30,000 columns into a table.  No, that is not a ...

It's Official, today! We have a party for SQL Server 2008 in LA!  The product may not be shipping, but that won't stop us from having our party. Seriously, Today marks the beginning of a more useful Launch than the 2005 launch.  What am I saying?  The Launch Events will probably be more educational for you this time around because ...

Yesterday Denis Gobo told you about 33 new DMVs in SQL Server 2008; previously, I had noticed that a few of the existing DMVs from 2005 had changed slightly.  So, Denis sparked my curiosity, and I ran the following query on a recent build of SQL Server 2008, which had a linked server pointing to SQL Server 2005: SELECT s1.vn, s1.cn ...