Determining an 'active' user count of an ASP.NET site
All we need is an easy explanation of the problem, so here it is. On an ASP.NET site, what are some techniques that could be used to track how many…
Mean Time to Failure (MTTF): When disk manufacturers post this, how should you interpret their numbers?
All we need is an easy explanation of the problem, so here it is. Mean Time to Failure (MTTF) is usually given in terms of hours, and by doing some…
Adding Custom Post Type Counts to the Dashboard
All we need is an easy explanation of the problem, so here it is. The dashboard conveniently tells me how many posts, pages, and comments I have. I would like…
Better way to get tag stats?
All we need is an easy explanation of the problem, so here it is. I have over 4000 posts. I am trying to query all the posts and get the…
Difference between show status and show global status in mysql
All we need is an easy explanation of the problem, so here it is. When I execute "show status" and "show global status" in MySQL at interval of 5 seconds…
Estimating distribution of row access in mysql
All we need is an easy explanation of the problem, so here it is. I am trying to get an idea of the size of the "hot data" part of…
How does sampling work when updating statistics?
All we need is an easy explanation of the problem, so here it is. I have several massive tables. I'd like to ensure their statistics are up to date via…
Unique index updates and statistics row modification counters
All we need is an easy explanation of the problem, so here it is. Given the following table, unique clustered index, and statistics: CREATE TABLE dbo.Banana ( pk integer NOT…
How are the number of Histogram steps decided in Statistics
All we need is an easy explanation of the problem, so here it is. How are the number of histogram steps decided in Statistics in SQL Server? Why is it…
Statistics. Are multicolumn histograms possible?
All we need is an easy explanation of the problem, so here it is. I am thinking of a situation where I have two columns with high density but these…
- 1
- 2
- 3
- 4
- …
- 6
- Go to the next page