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? The...
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.
