Deadlocks have been constant troublemakers for database professionals for years. They seem to show up from nowhere and keep on happening again and again. Pinal Dave provides some oversight.
2019-04-05
SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading
2019-01-15
3,258 reads
In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading
2018-12-10
2,593 reads
In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.
2018-07-10
4,171 reads
This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.
2016-08-05 (first published: 2015-06-09)
21,077 reads
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
2017-02-10 (first published: 2015-06-08)
16,739 reads
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Monkeytype Typing Club is a unique typing practice website that offers several features that...
Comments posted to this topic are about the item The Duplicate Cursor
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers