THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » New Features » Katmai   (RSS)
  • 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
  • No More HCL - in 2008

    The old Hardware Compatibility List which was renamed the ''Windows Catalog'' is no more.  When creating a Clustered Solution, you need to have a system that is Certified for clustering or there will be no official support.  This has been a point of pain in the past as organizations purchased a clustered solution and then one of the ...
    Posted to Rick Heiges (Weblog) by RickHeiges on December 19, 2007
  • Compression in DB Mirroring

    When you start to look at SQL Server 2008, there is a sub-theme of using compression to help drive performance and usefulness.  When I hear the word compression, my first thought is ''No - I remember Stacker''.  How many years ago was that obscure reference?  Too many...  Stacker was a third party product for MS-DOS which ...
    Posted to Rick Heiges (Weblog) by RickHeiges on November 20, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement