The Version Store Won’t Clear If ANY Database Has Open Transactions.
Short story: what the title says.
2025-11-24
Database Administration
2025-11-10
1,050 reads
2025-11-07
1,228 reads
2025-11-03
1,296 reads
Find Invalid Objects in SQL Server
This article shows how you can find which objects in your database might not be valid after schema changes.
2025-10-06
9,658 reads
2025-09-24
356 reads
2025-09-17
1,701 reads
2025-09-15
1,572 reads
2025-09-08
1,562 reads
Guidelines and Requirements
We have some requirements that we meet a particular setting or value, but often we have guidelines and recommendations. Do you know the difference?
2025-09-05
93 reads
Blogs
Lean Six Sigma – Brief
By Vinay Thakur
When you have a project or system, it has to be optimized, tuned, and...
T-SQL Tuesday #200: Bad Query signals
NO AI was used to generate this content. Grammarly was used to check and...
Project Management – Part 1
By Vinay Thakur
The soul of project management is Process Group(PG) and Knowledge Area(KA). they are related...
Forums
Reading Parquet using openrowset
Hi, We are looking out to read parquet file directly from on premise shared...
Impact of Single-Threaded PVS Cleanup on ADR in SQL Server 2019
We want to enable ADR on our SQL Server 2019 instances. I’ve heard that...
Forward Deployed Engineers
Comments posted to this topic are about the item Forward Deployed Engineers
Question of the Day
DBCC CHECKDB Limits II
I have a SQL Server 2025 database that I want to check for corruption every night. One of the things we do is disable indexes used for ETL loads during the weekend and re-enable them on Monday morning. If we run DBCC over the weekend, are our disabled indexes checked for consistency?
See possible answers