wish.mannat (6/11/2015)

---

Why am i getting these two errors on executing?

Msg 102, Level 15, State 1, Procedure MyProc, Line 16

Incorrect syntax near 'THROW'.

Msg 2812, Level 16, State 62, Line 1

Could not...

The semicolon is a statement separator. So...

After seeing question and answers yesterday, it was obvious that the script was incomplete. There was supposed to be an ALTER INDEX ... DISABLE in there - but for which...

ArnoKwetters (6/8/2015)

---

What is the advantage to disable indexes ?

I 've never used that.

Or I make and use an index,

or I do not make an index,

or I drop an index...

Robert Eder (6/4/2015)

---

Sean Lange (6/4/2015)

---

Robert Eder (6/4/2015)

---

The problem with script A is the constraint name will be system generated. Script B is also written to use a system generated...

David.Poole (6/2/2015)

---

I had a task that required iterating through a result set from a query. On a whim I tried it in a WHILE loop and then tried it...

g.britton (6/1/2015)

---

So, GOTOs have been "considered harmful" for almost 50 years!

It's a little surprising to me that no one has riffed that title to write a "Cursors considered harmful" article...

Alan.B (6/1/2015)

---

Until someone, anyone, can post an example where a cursor or other iterative method was faster than a well-written set-based solution I will remain convinced that the set-based solution...

Neither have...

I would not base any conclusion on cursors on the code in the MS databases. Some of it is really horrific. In fact, I have seen situations where the widely...

patricklambin (5/30/2015)

---

Hugo Kornelis (5/28/2015)

---

Okay, I am going to contest this one. I know that Books Online says that "Aggregate" can be "a logical operator or a physical operator". But who...

I'm afraid I can't...

Aggregate is a logical operator. It describes the process of applying aggregation function to data, (optionally) based...

DataTherapist (5/28/2015)

---

Say WHAT?!?

Apparently I have NOT been around the block enough times, because this was new to me.

I would have not suspected that 1/2 is NOT .5....!

No small wonder that...

Tony++ (5/28/2015)

---

Beyond the question of which answer is right, I want to know why I care. The poster of this QOTD must have thought there was something interesting or...