Alvin Ramard (4/18/2009)

---

That's the manager's job. My last manager did that several times. The only question she had to ask was: "What do you want on...

Check this blog series out. http://sqlinthewild.co.za/index.php/2007/08/20/reading-execution-plans/

Grant Fritchley's written a book on reading exec plans. I don't know if it's still available for download. I'm sure he'll drop by later and...

You've got SQL 2000 there, not 2005. Compatibility level 90 is SQL 2005. The highest level that you can set a SQL 2000 server to is compatibility level 80.

Lynn Pettis (4/17/2009)

---

I wonder if he will be able to put 2 and 2 together and realize he is in the same bucket of slop as that second contractor I...

magarity kerns (4/18/2009)

---

Look. the straight copy all from the script doesn't have any kind of sorting or anything to make a lot of overhead - do you really have production...

Works fine for me.

Exactly what command are you typing? (note that the <Database name> is just a placeholder for the name of the DB that you're changing.)

What does SELECT @@Version...

SQL Server doesn't use VBScript.

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic699960-146-1.aspx

Sorry, left out an =

ALTER DATABASE <database_name >

SET COMPATIBILITY_LEVEL = 90

magarity (4/18/2009)

---

1. Detach and copy the original mdf and lfd files. This works on my SQL Express between NTFS HDD and FAT32 USB. Is there something that prevents...

Memorising questions and answers is not going to help you pass an interview. You need to be familiar...

From Books Online:

sys.dm_exec_plan_attributes

User_ID

Value of -2 indicates that the batch submitted does not depend on implicit name resolution and can be shared among different users. This is the preferred method....

ALTER DATABASE <database_name >

SET COMPATIBILITY_LEVEL 90

Alvin Ramard (4/17/2009)

---

Lynn Pettis (4/17/2009)

---

Actually Alvin, your answer is perfect. It's what you are doing behind the locked doors with the phone off the hook that is important. ...

So go any buy it. It's well worth the small amount of...