2021-08-30
390 reads
2021-08-30
390 reads
A failed SQL Server Service Pack upgrade is fixed with a trace flag.
2020-07-27
4,806 reads
2019-12-26
483 reads
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
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
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,485 reads
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,939 reads
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...
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
The Mekong Delta is a beautiful region located in the southern part of Vietnam....
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...