Trace Flag Scope
- QotD Question
A failed SQL Server Service Pack upgrade is fixed with a trace flag.
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.
Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model.
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.
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.
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Hi, each day we are sent an email with an XML attachment. Recently the...
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
SQL Server Q&A from the SQLServerCentral communityGet answers