SQL Server: Performance Tuning :Understanding Set Statistics Time output
In the last post we have discussed about Set Statistics IO and how it will help us in the performance tuning....
2013-07-17
19,720 reads
SQL Server: All About SQL Server Statistics : Consolidated post
Statistics is the one of the important factor which helps the optimizer to choose the right execution plan.At the same time, many of us (so called DBA) will not...
2013-07-11
53 reads
SQL Server: All About SQL Server Statistics : Consolidated post
Statistics is the one of the important factor which helps the optimizer to choose the right execution plan.At the same...
2013-07-10
977 reads
SQL Server: Part 4 : All About SQL Server Statistics : Auto Update Statistics Threshold - Importance of Manual statistics maintenance
In the last post, we have discussed about the auto create and auto update property of the statistics. Do we...
2013-07-09 (first published: 2013-07-02)
4,947 reads
SQL Server: Part 5 : All About SQL Server Statistics : How to Detect outdated Statistics ?
In the last post, we have discussed about the auto update statistics threshold and concluded that auto updated statistics threshold are good enough to get optimal performance in some workload. In...
2013-07-09
44 reads
SQL Server: Part 5 : All About SQL Server Statistics : How to Detect outdated Statistics ?
In the last post, we have discussed about the auto update statistics threshold and concluded that auto updated statistics threshold are good...
2013-07-08
1,638 reads
SQL Server: Part 4 : All About SQL Server Statistics : Auto Update Statistics Threshold - Importance of Manual statistics maintenance
In the last post, we have discussed about the auto create and auto update property of the statistics. Do we really need to do manual statistics maintenance to keep...
2013-07-03
70 reads
SQL Server: Part 3 : All About SQL Server Statistics :Who Create and Manage the Statistics ? Role of Statistics in Performance Tuning
In the last posts, we have discussed about the histogram ,density vector and how SQL server use the statistics information in cardinality estimation. In this post let us discuss about how the...
2013-07-02
161 reads
SQL Server: Part 3 : All About SQL Server Statistics :Who Create and Manage the Statistics ? Role of Statistics in Performance Tuning
In the last posts, we have discussed about the histogram ,density vector and how SQL server use the statistics information...
2013-07-01
1,530 reads
SQL Server: Part 2 : All About SQL Server Statistics :Histogram
In the Part 1 about SQL server Statistics, we have discussed about density vector information stored in the the statistics. In...
2013-06-27
16,304 reads
Blogs
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Forums
Alamat BCA KCP Thamrin Nine Telp:0821°7555°651
Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...
Alamat BCA KCP Samanhudi Telp:08218200203
Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
Alamat BCA KCP AM Sangaji Telp:08218200233
Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers