Solved

Best practice fro 'snapshots'

Posted on 2012-04-09
2
181 Views
Last Modified: 2012-04-10
I am throwing this out for ideas...

I need to run a query against up to 4 tables/views and grab then put the results into a database - kind of like a snapshot but not sure if this is the best way to phrase it.

I need to store the results in a format where they do not change and label the new table with datestamp?

Ideas? Pro's/Con's
0
Comment
Question by:edrz01
2 Comments
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 37826490
Shouldn't you run one transaction in READ COMMITTED SNAPSHOT isolation mode, i e begin transaction, read and then commit transaction. This will ensure you get all rows from all tables in transactionally sync.

Write the lot to a new table that you create in the above transaction (given a special name)

If you don't need many tables, I would choose to write to one table, and set extended properties for that table and in that store date and time for last batch load.

Regards Marten
0
 

Author Closing Comment

by:edrz01
ID: 37827079
thx
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Date from a string 4 70
Strange msg in the SSMS pane 13 58
Unable to save view in SSMS 21 73
SQL Server Configuration Manager WMI Error 11 20
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question