There's no easy way to do this other than querying all the tables... Or, ensuring that the code that is generating your inserts is using appropriate data. The application shouldn't...

Not enough to go on.

First, fundamentally a deadlock is a performance problem. If all the locking occurs so fast that there's no interference, you will never see deadlocks. So, I...

It's funny that the biggest concern is actually guaranteed to happen. You are going to disrupt your existing work flow. That's sort of the point. I also see this as...

SQL Server doesn't manage it's memory in one giant pool. It segments the memory management into different areas with different purposes for efficiency of the management.

The plan cache is the...

Honest to god, I thought it was .index.

Great point and, I'm sure, an...

I joined an IT operations department in 2013. At the time, they were all on 2008 R2. I warned them at the time that they should begin upgrading immediately....

Now, Grant, to answer your question ("Tell me why rolling the dice and planning on good luck is the more sensible approach?"), my answer is only one thing; budget....

While I completely agree that a controlled upgrade path is absolutely valid for service machines, where I work we produce software dependent upon older environments for builds.  These are...

Oddball code bug related to rescheduling QOTD. It was scheduled for one day, moved to another, that affected the link. They're working on it.

Cheers Grant

Testing appears to be working, so I'm going for it. Just wondered if anyone else had tried.

I may ask a loaded question at one your SQL Bits sessions...

@Frederico...

Word is, it should be good now.

We need to fix it because I suspect there will be a little bit of a brouhaha about the question & answer today.

Nope, sorry, still not working. I'm speaking about "Join the discussion and add your comment" link at the end of the answered page. This also happened last week with...

I can't find anything saying one way or the other in Microsoft's documentation or on the real source of information, Niko's blog. I'd say if it tests out, it works....