Nice question to start the week ... reminded me of the basics once again.

As with most items concerning SQL and for your specific question "It depends", is in some regards the universal answer.

Now to obtain further details for various situations such as database...

Nice question .... but Steve had I know it was you who created the QOD would still having me wondering what the answer might be.

I use this to track when my system starts up ... might give you an idea on a method of doing what you desire to do.

http://www.sqlservercentral.com/blogs/briankmcdonald/2010/10/16/when-was-sql-server-restarted_3F00_/

wm.m.thompson (2/6/2013)

---

I just posted a question today.

I have gone back to see if there was any answers, but I cannot find the question. is there a delay in answering...

You are close to your problem, so may I inquire:

a). Your deletion of 200,000 records per hour, is this to be continuous that is for 24 hours per day,...

Let me expand on the above ... practice .. here on SSC answering questions...

A possible path of action for yourself.

a. Purchase a copy of the Developer Edition of SQL Server 2012 ... last time I checked AMAZON had it for $50 USA...

Not much different from this one

http://www.sqlservercentral.com/questions/Precedence/95143/

L' Eomot Inversé

nice question .. glad to see you contributing to the QOD to allow others to learn what you can teach.

You should know that those who want to help you are more than likely to be at their work place ... working .... could you supply the table definition, a...

Here is a quick method. NOT recommended for speed or flexibility ... If you would outline your requirements in greater detail perhaps some one can / will give you...

Without additional information, it is difficult...

Sean Lange

Hi it seems you are pretty new around here. Your description is entirely to vague for anybody to help much. Please take a few minutes to read the article...

Thanks for a clear, concise QOD .. and good to be reminded of the basics,