THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Katmai   (RSS)
Showing page 1 of 3 (25 total posts)
  • How do the links in YOUR copy of SQL Server 2008 Books Online work?

    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 / ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 19, 2008
  • It's Q3 - where is SQL Server 2008?

    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 ...
    Posted to Rick Heiges (Weblog) by RickHeiges on July 3, 2008
  • Are You Ready for SQL Server 2005? Use Upgrade Advisor for 2008!

    If you have systems that are still 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 ...
    Posted to Rick Heiges (Weblog) by RickHeiges on June 11, 2008
  • SQL Server has a new logo

    SQL Server's new logo has been published:   Courtesy of Wesley.  And I have taken a screen shot of the new splash screen for Management Studio:  
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on June 3, 2008
  • Some things don't change - Partitioning

    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 ...
    Posted to Rick Heiges (Weblog) by RickHeiges on April 27, 2008
  • SQL Server 2008 is getting close... I can smell it!

    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 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 1, 2008
  • Filtered Indexes

    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 ...
    Posted to Rick Heiges (Weblog) by RickHeiges on March 18, 2008
  • Increased limits for columns / indexes / statistics

    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 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 11, 2008
  • Happy Launch Day!

    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 ...
    Posted to Rick Heiges (Weblog) by RickHeiges on February 27, 2008
  • 16 Changed Dynamic Management Views in SQL Server 2008

    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, ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 7, 2008
1 2 3 Next >
Privacy Statement