stored procedures (sp) versus dynamic query

pivot tables in sqlserver

using checksum() function in sqlserver to generate hash key on unwieldy data keys for an index based on hash key bucketing

not that interesting, but some interesting points

cross tabulation or pivot table tutorial

the "get the extreme row from each group” query