The statistics tag has no wiki summary.
11
votes
2answers
7k views
What are database statistics, and how can I benefit from them?
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?
7
votes
1answer
196 views
Tracking stored procedure usage
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?
5
votes
2answers
285 views
Estimating distribution of row access in mysql
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 ...
2
votes
2answers
193 views
Problem with sp_Updatestats
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, ...
