The rows that lead the...

Interesting question.

I don't much like playing with MAXDOP as first response to an excess of XCPACKET waits. The optimizer isn't stupid but the default value of...

New to me too.

It seems odd that filestream isn't available in SQL Azure databases.

Eirikur Eiriksson (9/16/2015)

---

A more common scenario would be something like this, given the facts that:

a) Inserts and update are relatively inexpensive

b) Data comparison is relatively expensive

c) Good...

Eirikur Eiriksson (9/15/2015)

---

robin 66943 (9/15/2015)

---

This makes no sense to me. If the checksum is calculated differently, then when the checksums match that will most likely imply the data is different,...

sknox (9/14/2015)

---

I think the explanation is just plain wrong.

I don't see anything which would produce data types or numbers with the precision and scale of (2,1) or (1,1) --...

Nice simple question.

Of course branching is the easy bit. Merging the branches is harder. 😀

Grant Fritchey (9/8/2015)

---

Alvin Ramard (9/8/2015)

---

Steve Jones - SSC Editor (9/8/2015)

---

Jeff Moden (9/3/2015)

---

Alvin Ramard (9/3/2015)

---

Grant Fritchey (9/3/2015)

---

Another funny one today. Provided a DMV and a link to the documentation. I was...

But "JSON" is 5 or 6 letters too short for that, because with those first four words it has to be a truncated...

Trebbiano Rubiconi

I was sorely tempted to tick everything except "none of the above", but eventually left out the BI line because it was such a tiny fraction of my time even...

Yes, testing (including testing end user reaction to interfaces) and reworking when the tests indicate it's needed is similar to the scientific method. It won't deliver perfect, proven correct,...

A slightly awkward question, I think, since both the third option and the fourth option are correct with the question phrased as it is. Should really be phrased to...

Eirikur Eiriksson (9/5/2015)

---

J Livingston SQL (9/5/2015)

---

TomThomson (9/4/2015)

---

Eirikur Eiriksson (9/3/2015)

---

TomThomson (9/3/2015)

---

Ed Wagner (9/3/2015)

---

I would definitely attend your presentation on DBCC Timewarp. However, given the topic, expect some serious heckling. 😉

Those...

Eirikur Eiriksson (9/3/2015)

---

TomThomson (9/3/2015)

---

Ed Wagner (9/3/2015)

---

I would definitely attend your presentation on DBCC Timewarp. However, given the topic, expect some serious heckling. 😉

Those who have never heard of it...