+1 Me four... not that I depend on the crutch of having a (check 2) there or...

Hugo Kornelis (6/8/2013)

---

1. The scale of the data. Consider calculating the mass of a subatomic particle by multiplying its force by the square of its speed.

2. Scientific data usually...

Thanks for an easy one Ron....Personally I hate IIF... and wish that it would go away from apps... not get added to them. 🙂

Thanks for the question... easy one.... only because I've tried to do this too many times in the past.

I no longer try to do this... because I've found it generally...

Raghavendra Mudugal (5/16/2013)

---

Good one, IgorMi, thank you for the posting.

COLUMNSTORE index is very new to me and didn't had a clue on what it does, so have to take the...

Nice question on the fundamentals... thanks for it.

I think we should give Hugo bonus points for another awesome explanation...

Good question no matter what, and an even more awesome explanation from Hugo

I'll second that... then again my standards are to do any and all declares at the beginning of my SQL Batches/Stored Procs/Functions so I've...

Guess I need to light my torch... I'm totally in agreement here....

Very nice post, and something else I will use when Executives try to tell me that I should be creating new databases to store data that is related to data...

Hugo Kornelis (4/26/2013)

---

I first focused on the reference to a unique constraint rather than the primary key, thinking that was the issue of the question. I almost got it wrong...

The only prep work I tend to do is to make sure any projects I'm presently working on are at a safe stopping point.

I don't expect anything more than fire...

I needs my coffee... for some reason I was reading the question as... how many rows will be returned... and I saw the count(*) and went... 1 duh.... there's no...

I will totally second this statement. I sat there staring at the question...

I could rule out row one because...

JustMarie (4/10/2013)

---

We deploy to the SSISDB catalog at a project level using the .ispac file. Then the DBAs use the environment to set up the connections. Is anyone...