4000 rows is far from a large database (or at least that table is pretty
small). In fact, you can even do a visual inspection of all the rows if you
Make sure you keep your indexes "fresh" (have a scheduled job for DBCC
REINDEX or DBCC INDEXDEFRAG). Also, run DBCC CHECKDB periodically to detect
What version and what Service Pack level are you running?
"Jason Sirota" <com> wrote in message