I'm on my phone, so I may not be reading this right, but it looks like both spids have a Tran count of 2, so could there be other tsql...

Kerberos doesn't work with dns aliases. You have to use A records, not CNAMES.

Some advice for the OP, if you can take down your SAN by slamming it too hard, you should consider reducing your hba queue depth to limit the number of...

I'm going to assume that the new instances will be on new hw. if so, you'll more than likely have lots of cpu to spare. IO is harder...

Typically, you should release resources as soon as you are finished with them.

Designate one db the "owner" of the table, and force all inserts, updates and deletes to go there. Use a trigger and linked server to update the other tablein...

1. Document current functionality of existing dts packages.

2. Write stored procedures to duplicate functionality.

Of course, it may be easier to recreate the dts packages as ssis packages, not stored procedures.

A better option is to use a certificate signed stored procedure.

http://msdn.microsoft.com/en-us/library/bb283630(v=sql.105).aspx

Changing the max server memory forces invalidates the plan cache. Max server memory is a parameter that the query optimizer uses for evaluating plans. Different plans have different...

Jose Johnson (8/10/2012)

---

Those are some great suggestions - thanks. I had toyed with the idea about possibly using a stored procedure previously but hadn't really explored it in any...

Ok, a couple of things:

1. Your code is not robust. You are not properly escaping your input. You MUST use QUOTENAME() to sanitize the input when doing string concatentation.

EXEC('CREATE...

CRC (8/10/2012)

---

I have a table called 'warehouse_locations'. A row in the table looks like this:

site_idlocation_iddescription

0618a4 18a4

06...

Ok, saw you edited. justa sec.

Actually, now that I think about...

The difference in performance is due to either different plans, or blocking.

Can you capture actual query plans from both the slow and fast executions?