Performance Tuning Means 3 Things
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
Performance and Tuning
A Self-Tuning Fill Factor Technique for SQL Server – Part 2
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
2,858 reads
Waits and Queues
This week Steve is wondering if you know how to use waits and queues for troubleshooting.
2019-08-23
309 reads
A Self-Tuning Fill Factor Technique for SQL Server – Part 1
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
5,378 reads
Are your CPU-intensive queries running slowly? Check your VM type.
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
A Brief History of Deadlock and Modern Approach of Resolution
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 Logical Reads – What do they really tell us?
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
SQL Server Logical Reads – What do they really tell us?
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
Automatic Query Performance Tuning in SQL Server Database
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
SELECT INTO vs INSERT INTO on Columnstore
This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.
2016-08-05 (first published: 2015-06-09)
17,671 reads
Blogs
Daily Coping–3 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Data Céilí 2020 Cancelled
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...
Code from Redgate Streamed
By Steve Jones
I presented a session today at Redgate Streamed and did a number of demos....
Forums
Fully Qualified Name
First time poster...not sure this the correct section to post this question. I have...
expand field and fill with zeros
I am using this statement: Select @Data = @Data + RIGHT('00000000000' + CAST( (SUBSTRING(STR(@qtramt1),1,11))...
sp_send_email doesnt work when you insert @query
Hi all I have an issue when i try this it gives me an...
Ask SSC