Trend Rolling Table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » Trend Rolling Table

Trend Rolling Table

Rate Topic

Display Mode

Topic Options

Author

Message

Erin.

Posted Thursday, December 06, 2012 9:52 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:43 AM
Points: 1,151, Visits: 531

Development has created 7 day rolling tables on multiple servers. I want to pull this data over to another table so I can trend daily averages over a few months. The rolling table is populated throughout the day meaning data is added/removed every few minutes. What would be the best method to copy this data to my table without missing or creating duplicate rows?

Post #1393624

Erin.

Posted Friday, December 07, 2012 6:50 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:43 AM
Points: 1,151, Visits: 531

Debating on using replication or SSIS Lookup.

Post #1394292

Jeff Moden

Posted Friday, December 07, 2012 7:37 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:05 AM
Points: 32,894, Visits: 26,775

Erin-489205 (12/6/2012)

Step 1 would be to find out how they are deleting the data so you can intercept it.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1394298

ScottPletcher

Posted Monday, December 10, 2012 4:17 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 10:39 AM
Points: 1,318, Visits: 1,765

Replication could be problematic as SQL will replicate the DELETEs as well as the INSERTs.

Also, do you need to capture UPDATE activity or just INSERTs?

Finally, are you on Enterprise or Standard Edition?

CDC could work well for this if you are on Ent Ed (unfortunately, CDC is not available on Std Ed).

SQL DBA,SQL Server MVP('07, '08, '09)
One man with courage makes a majority. Andrew Jackson

Post #1394811

Erin.

Posted Tuesday, December 11, 2012 11:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, April 29, 2013 11:43 AM
Points: 1,151, Visits: 531

SSIS lookup is working well.

Post #1395248

« Prev Topic | Next Topic »

Permissions