SQL Server Diagnostic Information Queries for March 2014
I made a couple of changes in the order of the queries this month and made some other small improvements...
2014-03-11
1,654 reads
I made a couple of changes in the order of the queries this month and made some other small improvements...
2014-03-11
1,654 reads
On February 17, 2014, Microsoft released SQL Server 2008 R2 SP2 CU11, which is Build 10.50.4302. This cumulative update has...
2014-02-21
1,359 reads
I will be travelling to Copenhagen, Denmark to deliver a full day pre-con for SQLSaturday #275 on Friday, March 28,...
2014-02-12
922 reads
I improved the file-level latency query this month and made some other small improvements to a few other queries. Rather...
2014-02-06
1,146 reads
I spent some time this month to true up the SQL Server 2005 version, with the other versions for the...
2014-01-14
1,040 reads
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million...
2013-12-31
1,153 reads
Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 10, which is build 10.50.4297. This Cumulative Update...
2013-12-17
1,408 reads
I have made quite a few updates and improvements to this set of queries for December 2013. I have added...
2013-12-17
910 reads
Microsoft has released SQL Server 2012 Service Pack 1 Cumulative Update 7, which is Build 11.0.3393.0. This CU has 47...
2013-11-19
2,360 reads
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 14, which is build 10.00.5848. This Cumulative Update has...
2013-11-19
1,170 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers