Get a copy of Adam Machanic's free sp_whoisactive (v11.00 is current I think). READ THE DOCUMENTATION at the top of the sproc code!! AWESOME STUFF!

1) Syed - this person stated they have 100 rolling days of data (day comes in, one drops off). Why would you recommend YEARLY partitioning??

2) Partitioning CAN be great...

1) RTFM...

what type of plan are you getting?

are you filtering any rows or doing stuff (aggs?) with all 700M of them?

Sounds like an interesting problem, although I will say...

I note that you never stated WHY you are even considering a refactor? Is your existing query slow? And if so, have you done the following:

1) wait stats...

Perhaps this is a multi-threaded insert by SSIS, in which case rows can be interspersed and thus lead to nasty frag? Try forcing single thread.

Also, given width of actual...

You have been working at this for 4 days now. Get a performance tuning professional to give it a review and you should be able to see significant improvements...

1) You have been working on this for 6 days now! Get a performance tuning pro on your system and it shouldn't take more than a few hours to get...

1) sp_msforeachdb IS documented - you can generate the script of it's code and there is your documentation. You can also fix it with your own improvements.

2) ola.hallengren.com's stuff...

This is a VERY common scenario - just saw it yet again at a client earlier this week. If you have many NULLable variables and/or tables that you join...

For THIS poster's table (which has PK on identity) I agreed that your statement was correct. But it is NOT generally applicable, and many people read these forums and...

No one has mentioned doing a file IO stall and wait stats analysis while the process is running. You need to do that to find out exactly what the...

Just a suggestion: If all of your I/O activity on the table consists of insertions of new records and deletions of old records, I would consider setting the fill factor...

searching for strings is often best accomplished by using Full Text Search. I note that the 2008+ versions are much better than the 2005 one.

jamessdba (5/19/2011)

My manager asked me to track the Backend db correction

Ho to track the changes in the Db

example

suppose if i did not go to the office...