Create Database Snapshot Dynamically
Dynamic SQL can be used to generate a database snapshot. Useful for a database with a number of files.
2018-08-23 (first published: 2016-11-04)
1,767 reads
snapshot
Automated Rapid Recovery during Database Code Releases using Snapshots
Leveraging snapshots across multiple databases simultaneously to allow for quick rollback in case of a problem deploying code
2015-12-08
2,046 reads
2014-03-20
2,250 reads
2016-04-12 (first published: 2014-03-12)
2,275 reads
Successfully execute an INSERT, UPDATE and DELETE against a Database Snapshot
Not too long ago an ISV that developed solutions using SQL Server as the RDBMS, asked me how they could query a database as at a point in time. This was a relatively easy answer, thanks to the Database Snapshot feature. I was however surprised at the next question “Can we update the database snapshot?”
2011-12-21
2,509 reads
2009-07-27
3,108 reads
Blogs
ACM Lecture at SELU
By Will Assaf
Had the pleasure of presenting to Dr. Ghassan Alkadi and a full house at...
T-SQL Copy & Paste Pattern – Increasing a performance problem
By Cludio-Silva
Disclaimer: The title is my assumption because I saw it in the past happening...
Removing ad hoc plans from Query Store
By DesertDBA
This is not a post about the “optimize for ad hoc workloads” setting on...
Forums
To show the count per month from the date provided
I have two tables namely Vendors & Visits. Create Table Vendor (VendorId BIGINT IDENTITY(1,1)...
Two tables per page
I have this report, see below, that works great. Enter the employee number and...
How to find out HOW MANY inserts, HOW MANY updates happend in merge
How can i get the counts of how many records updated and how many...
Ask SSC