Skip to main content
Share Your Experience: Take the 2024 Developer Survey

New answers tagged

1 vote

SQL 2017 log reuse issue

What I didn't know is that for databases in AGs, VLFs can remain with a status of 2 even after they are freed up by a backup. https://www.sqlskills.com/blogs/paul/lazy-log-truncation-or-why-vlfs-might-...
Bruce Benson's user avatar
1 vote

Snapshot isolation transaction failed in database 'tempdb'

I've managed to create reliable replication steps for this error. I have a stored procedure that: runs a SELECT statement to output some data from a bunch of real tables waits for 1 second using ...
Dan Def's user avatar
  • 163

Top 50 recent answers are included