Not the first time I've seen that kind of thing from that person.

http://www.sqlskills.com/blogs/kimberly/determining-the-position-of-search-arguments-in-a-join/

Luis Cazares (6/6/2014)

---

That's why...

Still haven't got an answer to why the table is being partitioned in the first place. What's the point?

You don't.

Copies of the mdf and ldf are not backups. To restore point in...

All SQL triggers fire per operation....

patrickmcginnis59 10839 (6/6/2014)

---

GilaMonster (6/6/2014)

---

patrickmcginnis59 10839 (6/5/2014)

---

I'm going to be honest with you, as far as 2014 memory optimized tables(?) go, I don't know what standard behavior even is. I sure...

sybrand (6/6/2014)

---

This is the Important part and the way to shrink the Transaction log is to set the Recovery to Simple in properties, then go to Shrink File and select...

Well, the deadlocks by example article is only 6 months old, so not all that many intervening years. 🙂

It's not a single transaction deadlock, there are two processes, so two...

sqldriver (6/6/2014)

---

GilaMonster (6/6/2014)

---

pietlinden (6/5/2014)

---

If you dig around here even a little, you'll find Gail Shaw's explanation of what NOLOCK really does. You might need to make them read the...

SQL 2008 (as per the forum) or SQL 2012?

pietlinden (6/5/2014)

---

If you dig around here even a little, you'll find Gail Shaw's explanation of what NOLOCK really does. You might need to make them read the article she...

Read-Committed Snapshot Isolation

patrickmcginnis59 10839 (6/5/2014)

---

I'm going to be honest with you, as far as 2014 memory optimized tables(?) go, I don't know what standard behavior even is. I sure hope it isn't...

As I said, I'd be looking for external memory pressure when that happens.