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,663 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,663 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,368 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
925 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,152 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,048 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,154 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,420 reads
I have made quite a few updates and improvements to this set of queries for December 2013. I have added...
2013-12-17
919 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,374 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,179 reads
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
By Steve Jones
As I use containers more and more to run various things, I decided I...
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
The Spirit Airlines Newark Liberty Airport Terminal is well integrated into the broader transportation...
I maintain an application written years ago, where the database is on a Windows...
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers