SQL Server Diagnostic Information Queries for April 2014
I made some small improvements to a few of the queries this month. I plan to add several more SQL...
2019-04-02 (first published: 2014-04-18)
4,315 reads
I made some small improvements to a few of the queries this month. I plan to add several more SQL...
2019-04-02 (first published: 2014-04-18)
4,315 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,653 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,355 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,144 reads
As we get closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2...
2019-04-02 (first published: 2014-01-27)
2,455 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,034 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,406 reads
I have made quite a few updates and improvements to this set of queries for December 2013. I have added...
2013-12-17
908 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Comments posted to this topic are about the item Do you listen to music...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers