Thanks for the question, Simply Nice 🙂

(we have like 250+ database on each principals where the structure of each database is same, only the data stored is different, hosted on...

Thanks for the question, Ole. Interesting.. (before I knew very little about the merge, but know even little bit more... 🙂 )

Thank you, Thomas for the question, was set nicely.

With all the information provided and the associated non SQL section - I did not use any of my intelligence (what I...

Awesome question, Steve.

Never knew of this until now and while checking the BOL I came across the section "to edit the thesaurus file.." and in 2nd point it states;

If you...

alex.d.garland (2/7/2013)

---

Hugo Kornelis (2/7/2013)

---

So how should Steve have made a QotD about the dangers of select...

Awesome QtoD, thank you Steve.

(was thinking if the 4th option will come true in future versions, would be cool, and then thought again.. setting auto to everything is not a...

sipas (2/6/2013)

---

Almost... If there are no brackets, use BODMAS to work...

Dineshbabu (2/6/2013)

---

Raghavendra Mudugal (2/6/2013)

---

so, if no brackets then just start from L to R no matter what the operator is... and in the above given equation we don't know where...

sipas (2/6/2013)

---

Toreador (2/6/2013)

---

Yes, but...

archie flockhart (2/6/2013)

---

We learned the mnemonic as "BOMDAS" and also that the Multiply and Divide, and the Add and Subtract, were pairs of items of equal precedence.

Something like Bo[md][as]...

Hugo Kornelis (2/6/2013)

---

You could have saved that time. I just checked for which statements the parentheses matched the order SQL Server would use without parentheses and for which statement a...

Gary Stacey (2/6/2013)

---

I got it wrong!

I'd applied BODMAS to the 4 statements so I figured it was a different answer. Thought my reasoning was sound, so I checked the...

Good one. 🙂

(after lahhhhhhhhot of thinking and breaking them bit by bit finally (i think) understood the flow.. but i cheated by executing the code and picking the answer... NOT-:cool:)

the...

(well, to my knowledge understanding, I don't think precedence change according to the collation, and I think...

Awesome, thank you Tom.

(up until now never knew this, all the time i used simple case.... 🙁 even though BOL has mentioned this clearly i never looked it properly :-P...