Hi,
On DB2 there was a command called runstats() whichi made sured index tables etc were up to date. Is there an equivalent in SqlServer?

Also, if I have a very large table that gets a reasonable amount of use, is there any sort of periodic health cleaning I should do. For example, on my PC, every now and again I defrag the disk. And equivalent for a specific SQL table?

Thanks.

You could run UPDATE STATISTICS
UPDATE STATISTICS (Transact-SQL)
...but use it sparingly.

Thanks a mill! How to I determine the last time that was run?