How long would it take to rebuild 1) a clustered index and
2) a non-clustered index on a million record table?
Can this be run with users accessing the database?
This system has two processors and 256 MB ram.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …