Just to add a little more, you may want to take a look my blog post Comparing Hardcoded functions, In-Line TVF's, and Scalar Functions

Lowell, thank you for reference. Much...

Stressing! (Okay, Databasse Mirroring can be pain.)

Okay,...

Another thing, statistics could be different between the two systems, and this could affect the query plan generated in production compared to UAT.

To me it looks like an application issue. Unfortunatley, it appears it allows the wrong data to be entered into the wrong database. It maybe better to focus...

Requires restarting SQL Server from the command line using a switch (check with K Brian Kelley (sp ?)) which means you need access to the server; actually physically or using...

Question now...

Have a declare statement in your code? Try putting a space between...

krypto69 (2/1/2010)

---

Here's what I ran:

As an overview - I need to create a BAK file of the existing MSPHXX. Then, restore that onto my K and L voumes (DB &...

I don't see anything wrong with your comment. Now the OP might, but that is his problem, not yours.

If the database name already exists, the restore will not overwrite it unless you include the REPLACE clause in the RESTORE command. I didn't see that in the code...

san43 (2/1/2010)

---

I completely agree with all the arguments/suggesstions that every one has made here. My doubt is the same number of rows are retured for table variable in UAT(...

Bill Gates-870674 (2/1/2010)

---

OK, NOW:

Can you explain how much important it is for a DBA to know about system administration/HW/Servers? and why ?

AND

Does this also mean that an IT person has...

Part of it depends on when (date and time) the end of month backup is taken and if that time is consistantly the same.

milzs (2/1/2010)

---

OK, so.....

(A) If I change the recovery model from FULL to SIMPLE, then perform the DELETE will the delete action not be logged? I can then change...