When Page Prefetching Takes a Back Seat – Exploring Trace Flag 652 in SQL Server
Learn how a trace flag affects SQL Server reading from disk and where this might be a useful thing for you to enable.
2025-09-24
2,346 reads
Learn how a trace flag affects SQL Server reading from disk and where this might be a useful thing for you to enable.
2025-09-24
2,346 reads
2024-05-13
590 reads
2021-08-30
409 reads
A failed SQL Server Service Pack upgrade is fixed with a trace flag.
2020-07-27
5,711 reads
2019-12-26
502 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
979 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,494 reads
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
Comments posted to this topic are about the item Create an HTML Report on...
We have an issue where SSIS packages are failing with a status of "ended...
Hi everyone! I'm new to SQL and am trying to query a view (dbo.)...
What does a slipstream installation mean?
See possible answers