In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan -- Why? – SQLServerCentral. This article is a continuation of just how the optimizer interacts with the index wizard. We’ve all heard and read […]
2021-07-07
3,263 reads
Brent Ozar discusses performance tuning and how From the outside it looks more complicated than it is, but at the end of the day, it always comes back to just 3 knobs and knowing which ones you can turn.
2020-02-07
Introduction Fill Factor is a parameter most of us have ignored because there is no definitive way to calculate what the correct value should be. Part 1 of this series describes a new technique to dynamically determine index fill factors for all indexes within a database. Part 2 covers an analysis of the data collection […]
2019-08-27
3,774 reads
This week Steve is wondering if you know how to use waits and queues for troubleshooting.
2019-08-23
530 reads
Introduction So what’s all the fuss about Fill Factor? It is a SQL Server parameter I’ve ignored for 20+ years. The main reason was/is I’ve had no idea about what value to use. There is just no documented definitive guidance. Back in April at SQL Saturday #830 - Colorado Springs, I attended two sessions by […]
2019-08-20
8,417 reads
When you build a VM for SQL Server in Amazon EC2, Azure VMs, or Google Compute Engine, it’s all too easy to overlook the CPU speeds that you’re getting.
2019-05-03
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
Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...
By Rob Sewell
"Let me know where you get your magic pixie dust from!"
By Steve Jones
flashover – n. the moment a conversation becomes alive and real, when a spark...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Hi Everyone, I have the data in the below form : Desired output: Here...
What was the originally name of the appliance that eventually became Azure Synapse Analyics?
See possible answers