The link I gave you when I first asked...

It would depend on specifics of the app and server, but I'd say 6 months, maybe. Not just one month though. More than that.

You are aware that there is a chance it can can cause rows to be returned more than once, rows...

Ratings?

Points are given for posting or for correctly answering the question of the day. When your points are high enough (see the thread I referenced for the thresholds) your title...

Have a look here. Example B is almost exactly what you want to do.

http://msdn.microsoft.com/en-us/library/ms186734.aspx

Sure, and if that old data that has been removed creates free space that will not be reused...

No risk, just watch what you pick as the clustering key. A bad choice and everything might slow down a lot.

Just an aside, are you really sure that you want to be using nolock around financial transactions? I've worked in banks before, they're not usually happy with the possibility of...

I'd start by using RowNumber partitioned by the jobid and ordered by the date. Then you can select where that is <=10

Have a look at the QUOTENAME function. It should do what you want.

Braindumps are questions taken from the exam, in violation of the NDA that anyone writing the exam has to accept. Using braindumps is cheating and using or distributing them can...

See here: http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx

Sorry, don't understand your question. Can you explain more?

Can you post the entire error message and any other relevant details (like what the job does)?

I said it was a start.

The index is not covering, that's why you're getting key lookups. It's very expensive to cover a query that selects all columns. Hence the first...