Lynn answers people that I won't. I answer people that Jeff won't. Jeff answers ones that I won't, etc.

http://www.sqlservercentral.com/Forums/Topic691132-61-1.aspx

Braindumps are cheating. They are actual questions from the exams, disclosed publically in violation of the NDA on...

Maybe.

See - http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

Restoring from backup is the first prize if the mdf won't attach cleanly.

You may be able to find details in the default trace. It's a trace that's always running when SQL is running. Thing it, it's limited in what it stores, 5...

ta.bu.shi.da.yu (8/21/2009)

---

Turns out what I'm missing is that under the simple recovery model all you need to do is a checkpoint, then a shrink operation - which I just read...

ta.bu.shi.da.yu (8/21/2009)

---

Perhaps I'm missing something, but if I'm running the database under the simple recovery model, then why wouldn't I just be able to truncate away the inactive portions of...

Maybe.

Ok, without AWE or /3GB SQL will never be able to reach that 3GB max memory. On 32 bit, without either AWE or /3GB, max memory per process is 2GB.

Consider...

TheSQLGuru (8/21/2009)

---

If you join to a table on 1 (or a few) values and you hit 90% of the rows in the join table do you really want to do...

SQL 2000 or SQL 2005? What edition?

Go to the maintenance plan and have a look at what it does and then describe what the plan is doing. The command that...

Any pattern in when it happens? Any entries in the SQL error log or windows event log that coincide with the time it starts?

What OS, how much memory? Do you...

If you do get a difference, please blog it. Also, if you do get a difference, try OPTION (RECOMPILE) on the query, see if there's any change. Shouldn't be, recompile...

Has someone run DBCC FREEPROCCACHE? Restored a database or log? Run an sp_configure changing a setting?

Yes, there is.

Are you saying it is the same process...