Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-05-11 : 01:09:42
|
| I am working sqlserver 2008 we are maintainingg huge amount of data in my database tables (some of tables have more than 3 crore)we are maitaing data from last 4 yearswe are facing very critical performace issueSo we want to know the archive process can anybody explain how to do the ARCHIVE PROCESS IN SQLSERVER AND What are advantages in ssms. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2012-05-11 : 01:37:20
|
| Do you query all those records?After Monday and Tuesday even the calendar says W T F .... |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2012-05-11 : 07:35:08
|
| YESWE ARE FETCHING STAGING DATABASE TO FRONT END REPORT GENERATIONmohan |
|
|
|
|
|
|
SSMS 2008 -ARCHIVE PROCESS