Nicely done. Absolutely excellent first article.

If I may, I'd like to clarify a couple of points. I wouldn't classify XML as a separate plan type (although I probably did in...

It could be the network configuration, but it's hard to say. I'd suggest capturing the query metrics on both machines, the execution plans on both machines, and, most importantly, the...

Patches should pretty much always be applied, but it sounds like you have some type of translation issue going on. Something in your code has told SQL Server to expect...

rodjkidd (2/18/2014)

---

Went to the London UG / SQLSupper with Mark Souza, Connor Cunningham et al for 2 hours of, I guess you would call a State of the Union...

Ingrate!

Kidding.

Interesting take. I sure don't think that management hands down tablets for us. In fact, the opposite. We should be telling management what we're doing and how we're doing it....

Sorry, based on such a general and vague set of information, I can't even begin to guess where the issues may be.

Look at the execution plan to understand how it's...

arrjay (2/17/2014)

---

Thanks for your response Grant!!

Grant Fritchey (2/17/2014)

---

Also, using table locking hints is pretty severe in terms of blocking off access to the system. Are you sure you need that...

Luis Cazares (2/17/2014)

---

You can read the stairways[/url] in this site, as well as the articles. You can try to solve problems from the forums even if you don't post the...

I'm going to take a guess and assume that you're not talking about my session called "Best Practices for Database Deployment" because I get into a lot of what you're...

Track down a local user group and attend their meetings. There are also SQL Server events in the UK that are free. There are SQL Saturday events and SQL Relay...

Yeah, I'd make sure that you're using WITH MOVE. It could just be that it's overwriting the files... which would only be possible if the database is offline.

I think Jason's approach is better, but you could just disable the login from a SQL Agent job and then have another at the scheduled interval to disable the login....

It really depends on how and where those 70 columns are coming from. You say it's a query to a linked server, are you joining a bunch of other tables,...

You're taking out locks on both queueitem and handrule. It could be that the differences in order between those locks and the ones needed by the index rebuild could be...

You can disable logins. As far as a certain amount of time, I don't think there's a disable for a time period, but you could set up two jobs, one...