xsevensinzx (12/4/2015)

---

I really don't understand this article at all.

NoSQL is such a broad topic that you really can't push out blanket statements about everything under the NoSQL umbrella much...

william-700725 (12/9/2015)

---

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

---

I don't have fundamental problems with gathering some of this data. Now keeping it, that's perhaps something we don't want to do. However we...

I thought it was...

william-700725 (12/9/2015)

---

I would suggest that the growth in the volume of data stored does not reflect a growth in actual information.

If you look, how much of that growth is...

Sean Redmond (12/9/2015)

---

A part of this increase in data-size is our sloppiness in database design. We throw in GUIDs everywhere partly because it is in fashion, partly because it makes...

Could it be that once you've restored it someone runs something that does an ALTER DATABASE to turn mirroring on the dev db?

Otherwise, I'm not sure. This shouldn't be an...

Probably

Rod at work (12/3/2015)

---

Argh!! Steve, please stop writing articles that interest me so much. Ones that I want to respond to. Believe me, I want to respond to this, but...

On the list

Can you not join to dm_exec_sessions here?

INNER JOIN sys.dm_exec_sessions AS des

ON des.session_id = r.session_id

Yes and no. We've almost always required a login, which helps us support the site, and I've been hearing this complaint for 15 years.

We are looking at some work to...

Last tie breaker is who beat Steve the most

My vote is you write this:

with mycte (col)

as

(select ...

);

If you get a syntax error because:

select mycol from mytable

with mycte (col)

as

(select ...

);

then you do this:

select mycol from mytable;

with mycte (col)

as

(select ...

);

I...

ditto.

I CTRL+B,...

Rod at work (12/2/2015)

---

Oh Steve, man have you said a lot here that I'd like to respond to. But I think prudence forebears me from saying everything I'd like to....