Browse by Tags

• Education
• Katmai
• New Features
• SQL 2005
• SQL 2008
• VM

• Recent Mags

  I get several more "generic" IT mags sent to my home. I usually get them in an attempt to keep up with what is going on in the outside world. Typically, I look at the lead story and find a nugget or two in the rest. In my recent issue of TechNet magazine, Read More... Posted Tuesday, July 29, 2008 4:13 AM from Rick Heiges | (Comments Off) Filed under: SQL Server Performance, Education, SQL 2008, SQL 2005

• 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

• SQL Server on VM

  Recently, someone asked me a question about consolidating SQL Server to VMWare. Here is my response. Microsoft has a webcast on their TechNet website that discusses SQL Server on MSFT’s virtual server. You can draw some conclusions as well that this also Read More... Posted Friday, February 16, 2007 10:25 PM from Rick Heiges | (Comments Off) Filed under: VM, SQL Server Performance