We review our SQL Servers every morning looking for "Corrupted" next to the database name. We also have alerts set up to e-mail us. We were having some problems with...

Interesting thread! A couple posters have good justifications for not putting a PK on a table. In my databases I would only allow that if the table records were guaranteed...

Thanks. Actually, I ran the query six times with elapsed times from 38 to 48 seconds and an average of 45 seconds.

I'm told that this query scans every page in...