I've had no serious accidents in 10 years of driving. One very minor bumper bashing and several close calls though.

Closest call was a couple years back on a highway. There's...

Bristolred (12/11/2008)

---

Basically your saying you have to be prepared for the complete worst i.e. disaster recovery if the whole server was to pack up/catch fire or the drive the log...

Glad to hear that.

Bear in mind that, with the exception of TempDB, running that does not move the files. It just changes the metadata. Once you've run that you need to take the...

I don't think there are any books specifically for that. The 447 exam covers all the material that 443 and 444 together do. It's just in 1 upgrade exam instead...

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...