2021-08-30
385 reads
trace flags
SQL Server 2012 does not come up after service pack upgrade SP4
A failed SQL Server Service Pack upgrade is fixed with a trace flag.
2020-07-27
4,450 reads
2019-12-26
480 reads
Properly Persisted Computed Columns
Paul White walks through a new trace flag in SQL Server 2016 designed to yield better execution plans (and performance) for queries involving computed columns.
2017-06-20
4,841 reads
2017-03-10
966 reads
Trace Flag 2389 and the new Cardinality Estimator
Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.
2016-08-23
3,480 reads
Testing SQL Server Backup Performance with Trace Flag 3042
Starting with SQL Server 2008 a new feature which allowed us to create compressed backup files by pre-allocating space. This tip will look at the performance impacts of disabling pre-allocation of space using the 3042 SQL Server trace flag.
2015-05-19
6,584 reads
2014-12-04
1,484 reads
Next-Level Parallel Plan Forcing: An Alternative to 8649
The trace flag 8649 is incredibly useful. Alas, the flag is undocumented, unknown, and its full impact difficult to understand. Adam Machanic presents an alternative which you might find useful.
2013-12-23
2,190 reads
2011-09-15
1,937 reads
Blogs
Honored to be a Microsoft MVP Again
By Steve Jones
I was renewed this week as a Microsoft MVP. This is my 15th award...
Daily Coping 6 Jul 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Establishing a Connection to PostgreSQL with GoLang
Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...
SSIS - Name of Excel Sheet - How to Clear Dropdown List?
I am trying to create an SSIS package inside Visual Studio 2019. This package...
How to create a linked service to a VM where I will copy files from Blob storage
I have files in Blob Storage that I'd like to copy over to a...
Ask SSC