Brandie Tarvin (4/6/2016)

---

977stijn (4/6/2016)

---

I'm still trying to replicate the deadlock in my test environment. With just the queries provided from the deadlock graph I haven't yet found a way to...

977stijn (4/6/2016)

---

Jacob, thanks for taking the time to both clearly explain and give an example. I must say everything you say makes sense and would explain where the RangeI-N comes...

My experience with this is about 6 or 7 years in the past. I remember getting the issue and how we solved it. That's about it. Sorry.

It is VM vs. Hardware, which can't be discounted. Just because the resource settings in the VM are the same as the hardware doesn't mean they're actually the same. The...

As a part of your development process, I strongly recommend you get your database into source control. This gives you the ability to track changes and, quite importantly, easily recover...

Also worth pointing out, with connection sharing, you may see a single connection that's been on for hours, but it's actually been used by a large number of people over...

There's no need for this. What problem are you trying to solve?

Upgrading to 2014 or 2016 is basically an identical amount of labor. With that in mind, I'd go for 2016. Yeah, it's newer, it might be a little rocky in...

Also, fair warning, if you encrypt a file, it won't compress well. Good backup software compresses, then encrypts.

SQLRNNR (4/5/2016)

---

Grant Fritchey (4/5/2016)

---

Oh god...

"The delete works sometimes"

... Surely, please,...

Sachin Nandanwar (4/5/2016)

---

This has been a known issue on atleast SQL...

Seems the OP removed the query. Shame. I'd love to see the execution plan. The query, all by itself, didn't seem to have any obvious issues. I'd be curious what...

Oh god...

"The delete works sometimes"

... Surely, please, tell me this...

That sounds like an issue with statistics or possibly a bad parameter sniffing issue (or both in combination). Recompiling the procedure causes it to create a new plan based on...

Oh, we're going off memory here. I did run into this issue on 2008r2, but only with a single app. We tracked down which app was having the failure and...