Bristolred (12/11/2008)

---

The data pages changed in memory will be written to disk (datafile - MDF) at a later time either by the lazy writer process or by the checkpoint process....

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic618052-1291-1.aspx

I can't see the full question, so I'm guessing a bit. If you're seeing the database marked 'in recovery' it's either a long restart-recovery, or a problem.

Can you get the...

Continued here: http://www.sqlservercentral.com/Forums/Topic617982-8-1.aspx

Please don't cross post. It just wastes peoples time and...

And even those who are not monolingual (British English and Afrikaans) may not understand the terms.

That's a column alias, not a table alias. The select clause,...

Can you post the table schemas, and the index definitions please?

How many rows is a lakh?

Back to the original problem.

There are two things causing the slowness.

First, the use of union. If you change all to union all, you'll get the same result (the resultsets can't...

I don't have your users table, and hence cannot reproduce your test. I tried one using similar queries and the temp table that I specified for an earlier test.

I ran...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic617605-5-1.aspx

Have you referenced the...

I'm still not understanding what you want.

The most recent query?

The most recent data change?

Something else?

Best bet to get any of that is to have a profiler trace running for any...

Well, yes. For the first one, the data has to be...

Sure....