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,246 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,246 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
2,042 reads
I’ve started my own SQL blog. Hopefully I’ll write some interesting SQL blog posts here soon.
2011-12-16
532 reads
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Accelerated database recovery was introduced in SQL Server 2019 and provides fast recovery, instantaneous...
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
Comments posted to this topic are about the item Create an HTML Report on...
Hi everyone I have a SP that finds the average based on 3 tables. ...
I have a large table with 17M+ rows for our package record audits. I've...