Best practice fro 'snapshots'

edrz01
edrz01 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Expert/Infrastructure Architect
Commented:
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

Author

Commented:
thx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial