The SQL Server set statistics time statement displays the number of milliseconds to parse, compile, and execute a T-SQL query statement. This set statement is widely used to assess times to implement a query statement. The set statistics time statement reports the CPU time and elapsed time for performance tuning.
2020-05-08
2020-03-03
Kendra Little talks about write ahead logging in SQL Server, one of the basic concepts that developers and DBAs should understand.
2020-01-20
277 reads
This article discusses sp_PerfSQ a diagnostic tool designed to quantify performance features of database queries with active requests. It includes a behavioural parser and can assist in troubleshooting complex performance issues.
2019-12-02
6,868 reads
2020-03-03 (first published: 2019-11-25)
4,097 reads
A forum question came up a few days ago regarding an abnormally large procedural cache. In an attempt to help out, I threw together a few ideas (some wrong, some right) and started looking at the types of query that were in the cache. A lot of the queries were in the format select * […]
2019-11-11
4,525 reads
2019-10-28
5,425 reads
2019-06-10
997 reads
2019-05-24
Batch Cussidy In the last post, we looked at how S...
2019-05-24
By Steve Jones
I wrote about sequences in an editorial recently and decided to start using them....
By Steve Jones
An online conference is coming on June 17, 2020 that is full of high...
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever...
Q1 -- I have read quite a few articles on page splits and am...
I am trying to monitor the sql services on couple of instances and found...
Ask SSC