I've heard mention of statistics that SQL Server keeps by default. What are they tracking, and how can I use this information to improve my database?
Besides using SQL Server Profiler, is there any way to track which stored procedures are being used, or at least when they were last executed?
I am trying to get an idea of the size of the "hot data" part of a rather large table, and I was wondering if this could be done directly in mysql. I know that with the percona version of mysql, I can ...
I am having a problem when running sp_updatestats on my database it generates an error when my emp table is updating and disconnects I will paste the error here Updating [dbo].[emp] Msg 0, Level 11, ...