Browse by Tags

• high availability
• SQL 2008
• SQL Community
• SQL Server Performance

• 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; Read More... Posted Wednesday, March 19, 2008 2:47 AM from Rick Heiges | (Comments Off) Filed under: SQL Server Performance, SQL 2008, Katmai, New Features

• 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 Read More... Posted Thursday, December 20, 2007 12:25 AM from Rick Heiges | (Comments Off) Filed under: SQL Community, SQL 2008, Katmai, high availability, New Features

• 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? Read More... Posted Tuesday, November 20, 2007 9:19 PM from Rick Heiges | (Comments Off) Filed under: SQL 2008, Katmai, high availability, New Features