Query Store Error State
We recently discovered some of our databases in an Error State for SQL Server. Microsoft has indicated this is a race condition when failover/restart happens on QDS cleanup. They...
2018-06-26
3 reads
Tracy Boggiano
Query Store Usage and Adaptive Plan Tuning Usage
Recently, there are have been a few articles about the lack of adoption of Query Store. Note the following:
Brent Ozar...
2018-06-17
70 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem
My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index...
2018-06-11 (first published: 2018-05-29)
1,647 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
2 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
6 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
6 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
3 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
1 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
3 reads
Spreading Job Run Times Out on an MSX/TSX Scheduled Job
Problem My company heavily uses MSX/TSX jobs for everything. But our SAN doesn’t necessarily like if we run all our index maintenance, backups, and integrity checks at the same...
2018-05-29
4 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers