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, the cover story is on how to Tune up your database by Paul Randall.  He ...

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 ...