Slow inserts across a linked server?
Linked Servers offer a great way to connect two SQL Servers together, allowing remote querying and DML operations. Frequently, this is used to copy data from production to reporting. However, the temptation is to run…
Does dm_db_stats_properties track statistics properties for “small” tables?
A recent question on dba.stackexchange.com about statistics properties asked the following: dm_db_stats_properties does not keep track of small tables? what is the work around to find the number of records in the table? The question…
Update Statistics on a Columnstore index failed
SQL Server relies upon good, up-to-date statistics when creating query execution plans. Out-of-date statistics can cause queries to run slowly, or suddenly start consuming far more resources than is typically required. Columnstore statistics are quite…
Transaction Log Structure
Intro This post shows the internal logical structure of the SQL Server Transaction Log. The details here target SQL Server 2000 to 2017. Note that SQL Server 2019 will likely include Accelerated Database Recovery, aka…
VLF truncation in SIMPLE recovery model
I recently presented a session on log file management where I discussed monitoring and managing the logical segments of the transaction log known as Virtual Log Files, or VLFs. A great question came up about…
I’m Sorry, I Can’t Let You Expand That Log File, Dave!
Thanks to all the wonderful people who attended my recent presentation on Transaction Log File Management at the Winnipeg SQL Server User Group Meeting! I had a lot of fun, and hope you found the…