Nice general advice, really liked the hero link from that post:

http://al3x.net/2010/01/09/dont-be-a-hero.html

It resonates for me because we have still got some hero code, the source of which cannot be traced, so...

Personally I'd suggest that if you are creating two temp tables...

Nice function, didn't remember that one coming in. I'd argue that maybe for some cases CASE might still be a little clearer, if more unwieldy, but options are always good.

I surely do feel that way. It's a frequently anxiety inducing experience and often stubbornly frustrating but correspondingly rewarding. In a strange sort of way that comes regardless of the...

I confess I'd have struggled to actually work these out in any way so apologise for 'cheating' (I ran it on my desktop instance) although I think learning about grouping...

Bring out the Chaos Monkey!

http://thenextweb.com/insider/2013/03/03/how-your-business-could-learn-from-chaos-monkey/

I'm sure you all know about him, but I just love the name.

On the shared / dedicated model thing for Red Gate SC, we use shared and are totally happy with that route, despite the seeming preferences stated here. I understand why...

Steve Jones - SSC Editor (5/17/2013)

---

call.copse (5/17/2013)

---

We are still non-distributed, and use SourceGear Vault, happy enough. Anyone got compelling reasons to go distributed?

The only time I have not checked any...

We are still non-distributed, and use SourceGear Vault, happy enough. Anyone got compelling reasons to go distributed?

The only time I have not checked any code in recently is when a...

IgorMi (5/16/2013)

---

Hugo Kornelis (5/16/2013)

---

Raghavendra Mudugal (5/16/2013)

---

From BOL - "A table with a columnstore index cannot be updated" - seems likes the table will become as a look up table or...

I agree this was obviously not a question about the error from lack of an alias. Interesting one which I did not know.

Nice back to basics question, thanks!

(Do I get an extra point for 'most inappropriate comment'? 😉 I enjoyed the explanations, my takeaway is avoid triggers in general, especially on views.)

I found this interesting and was unaware of this property, which is not like other code environments / execution. I won't be taking advantage, but knowing it does mean I...

I got it right by reading the documentation and assuming the question had been inverted by ascertaining that there were 3 official hints that did not require WITH, so if...

I thought the question was expressed well Nenad and had no problem with the clarification provided by the specified identity insert value - cheers.