Any particular reason you're running SP2? It's been out of support for a while now so you should be...

Any particular reason you're not considering doing a backup and restore? Even with large DBs you can fairly quickly get up to current point in time by doing something...

The SSMS Tools Pack can do that:

http://www.ssmstoolspack.com/

It can also save queries that you've run and windows you have open which can be very handy.

Your best bet is to talk to the DBA that maintains SQL on that server. While there is a default port you don't need to specify the port if...

There are a few different reasons to use stored procs. Plan reuse is one of them. Particularly on more complex queries the fact that it doesn't need to...

You could also do an existence check on sys.objects for the table name or check that object_id('tablename') isn't NULL.

For Windows updates, the application owners can either take the automated off-hours reboot when the update goes out or plan it themselves around the users schedule (which they do is...

See the first "Important" note in...

I haven't played with the lock_escalation setting but I would use it with care. It's possible for lock escalation to be triggered due to memory thresholds and if there...

TheSQLGuru (3/6/2012)

---

Well, I didn't say "never". 🙂 Likely your query was able to do an ordered operation or 'rely' on the PK (or it's likely clustering) in some other...

TheSQLGuru (3/6/2012)

---

In the vast majority of cases I have come across at clients a PK (or any index for that matter) on temp objects was NOT helping the query at...

But you can declare a primary key which does have an effect on how the query is processed.

ChrisTaylor (3/6/2012)

---

Your statement is incorrect - if you have a reference that says otherwise please provide it.

In this particular case a table variable will likely be best, because...

TheSQLGuru (3/6/2012)

---

Another suboptimal thing in this article is the non-clustered indexes. They serve no purpose in the queries and impose the significant overhead of building them every loop. ...

The thing I'm most looking forward to with contained DBs is mirroring. I'm worried that we'll hit a failover and a SQL job will have been updated on one...