xsevensinzx (5/18/2015)

---

The CmdShell calls is a good argument on why scripting is needed and why it should be kept separate. I can't do CmdShell calls. I rather a separate system...

Jacob Wilkins (5/18/2015)

---

Just to point out an alternative, instead of using multiple EXCEPTs, each with a SELECT pulling a set you'd like to exclude, you could also just UNION the...

David.Poole (5/18/2015)

---

100% testing is a worthy aspiration and we should all strive towards it in the same way that an Olympic athlete strives to beat world records. Just don't...

Onager (well, many managers are wild asses)

ChrisM@Work (5/18/2015)

---

Like this?

SELECT

t.*,

x.RollingSum

FROM #team t

OUTER APPLY (

SELECT RollingSum = SUM(expense_amt)

FROM #team ti

WHERE ti.team_id = t.team_id

AND ti.date <= t.date

AND ti.date >= DATEADD(month,-3,t.date)

) x

WHERE t.date >= DATEADD(year, -1, GETDATE())...

Jeff Moden (5/17/2015)

---

Heh... I look at the recommendations for "scripting" languages with a bit of disgust. There are so many things that SQL Server does very well through T-SQL...

I was amused to see "VBScript works fine". It's a statement I disagree with, totally and utterly.

1) If you want an MS only scripting language, learn PoSH, not VBScript....

Jeff Moden (5/17/2015)

---

I'm amazed at this question for 2 reasons...

1) The coverage for such a question in Books Online is not obvious. You actually have to infer that such...

Nice clear and straightforward question.

Given the vast proportion (three quarters) of wrong answers, it evidently isn't as easy as it looks. That surprised me. I guess...

Straightforward question,

It's a bit surprising how many have it wrong so far (more than half) because the four functions in the three wrong options have all been around since long...

GilaMonster (5/17/2015)

---

Jeff Moden (5/16/2015)

---

GilaMonster (5/15/2015)

---

David Webb-CDS (5/15/2015)

---

You gather the customer, the developer, the network guys, the storage guy, and the server guy in a conference room. They all swear...

Jeff Moden (5/16/2015)

---

I was interviewing one person who claimed over 10 years working as a Senior DBA and "tuning experience". Here's how the clustered index segment went.

Me: Tell...

A big part of the...

Of course we're both right. Jeff is never wrong. ...

Grant Fritchey (5/15/2015)

---

It's legal. I've seen this before. List all the tables and then all the...