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.

I'd go with what Hugo said. Also, it's my preference if the question can use some more memorable field names just to try and help make sense of what is...