This article presents a utility that will show you what SQL statements are using the transaction logs, in terms of log space used and transaction duration.
2016-06-17 (first published: 2015-03-10)
15,732 reads
Often when tracking down problems, you need to know if anything has changed recently, this script will tell you...
2015-10-20 (first published: 2013-05-30)
3,904 reads
This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving these targeted indexes, leading to better performing code.
2012-08-03 (first published: 2009-09-17)
42,546 reads
This article describes a utility that allows you to inspect cached plans and extract information that can be useful in improving the performance of your SQL.
2012-06-22 (first published: 2009-06-11)
47,534 reads
This article describes a utility that is able to report the most common DBCC CHECKDB errors significantly faster than DBCC CHECKDB does itself.
2011-08-23
15,342 reads
This article describes a utility that allows you to identify what SQL statements are currently executing.
2009-12-11 (first published: 2008-10-28)
62,905 reads
The utility described in this article allows you to quickly identify which columns have mismatched data types across tables in a database. Correcting these will improve performance etc.
2009-01-19
12,158 reads
The attached article describes a utility that allows you to quickly identify which queries are running slower than expected. Note this article was updated to correct the formatting issues.
2008-08-14 (first published: 2008-08-07)
24,797 reads
SQL Server 2025 RTM is here, and if you’re running Docker on macOS, you...
By Steve Jones
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m...
By Brian Kelley
I mentioned this in my talk on Quantum Computing at the PASS Data Community...
WIRE-ID:(@Math888) Instagram GBL wheel cleaner New Zealand. Telegram:(@Gblwheell) Solvent GBL alloy wheel cleaner Tel...
Hi, I want to find all the tables name under a database where tables...
Comments posted to this topic are about the item The Ending Substring
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers