Why you may or may not consider using Database Snapshots!
Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...
2011-12-17
8,235 reads
Microsoft introduced database snapshots with SQL Server 2005. A database snapshot is a static, read-only copy of a source database...
2011-12-17
8,235 reads
As we know xp_fixeddrives can only be use to retrieve normal fixed drives space information. It cannot be used to retrieve information...
2011-12-16
1,993 reads
I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.
2011-12-16
530 reads
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...
Verified on latest CU 10 for SQL 2022. Confirmed works correctly on SQL 2019...