It's not that you set up full blow failover clustering. But you have to set up the clustering services. The documentation is pretty clear on exactly how you have to...

Buy more memory. My laptop has 32gb of ram. Running a SQL Server instance on 4gb in this day and age is crazy.

Problem with only having the wait statistics after the query and not both before and after is that we can't tell what waits were experienced by the query. You need...

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....