Do you recommend DBCC CHECKDB or DBCC REINDEX ?
If DBCC REINDEX, is there a way to have it run across all tables in the database?
2 cents is still...
Interesting comment about indexes.
Would I be able to tell that they are using optimizer hints in
encrypted stored procedures?
Thanks for the...
The script to update statistics changed to the database, then "exec sp_updatestats".
Is there a better way that this should have been done?
Could you elaborate a little on other potential reasons?
We did update statistics on the all of the databases on the system.
The application itself...
We have an 8-way server running just SQL on Windows.
The performance of the system was OK when it was running WinNT and SQL7.
When we installed...
Separate names with a comma.