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,778 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,547 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,544 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,353 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)
63,019 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,167 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,810 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers