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,329 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,329 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
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,462 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
913 reads
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
By alevyinroc
It seems like no matter how long you work with a system beyond a...
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
hi i imported a tabular model from production into vs 2022, changed the data...
Hi I have just installed again on win 11 sql server express 2022 with...
Comments posted to this topic are about the item Understanding Bit Manipulation Functions: BIT_COUNT,...
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex] FILE = N'thirdone' , FILE = N'thirdtwo' , FILEGROUP = N'second' TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak' WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GOSee possible answers