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,659 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,659 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,365 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
924 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,150 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,045 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,419 reads
I have made quite a few updates and improvements to this set of queries for December 2013. I have added...
2013-12-17
914 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,371 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,177 reads
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and...
This may or may not be helpful in the long term, but since I’m...
By Steve Jones
“I’m sick of hearing about Red Gate.” The first article in the book has...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Pitfalls to avoid while feeding...
Comments posted to this topic are about the item Column Adds and Drops
I run this batch on SQL Server 2022. What happens?
ALTER TABLE dbo.Accounts ADD AccountAccessType INT GO ALTER TABLE dbo.Accounts DROP AccountAccessType GOSee possible answers