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,303 reads
Glenn Berry
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,651 reads
SQL Server 2008 R2 SP2 CU11
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,354 reads
Scaling SQL Server 2014 Pre-Con in Copenhagen
I will be travelling to Copenhagen, Denmark to deliver a full day pre-con for SQLSaturday #275 on Friday, March 28,...
2014-02-12
920 reads
SQL Server Diagnostic Information Queries for February 2014
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,142 reads
Vote on Connect Items for SQL Server 2008/2008 R2 and 2012 Service Packs
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,454 reads
SQL Server Diagnostic Information Queries for January 2014
I spent some time this month to true up the SQL Server 2005 version, with the other versions for the...
2014-01-14
1,032 reads
2013 in review
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
SQL Server 2008 R2 Service Pack 2 Cumulative Update 10
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,396 reads
SQL Server Diagnostic Information Queries for December 2013
I have made quite a few updates and improvements to this set of queries for December 2013. I have added...
2013-12-17
906 reads
Blogs
The Effectiveness of Solar Estimation
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and...
Daily Coping 24 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Shared Work Spaces: Hell, Heaven, Both?
Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...
T-SQL : Slicing time Islands and gaps
Hello, Consider the following table that gives the validity dates of an item :...
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
Ask SSC