I'm really curious to follow this for ideas. My company takes team building seriously and I recognize its importance... but I'm also a serious introvert and generally hate spending time...

There is a price in learning for users, who mentally hold on to limitations that no longer matter because they learned them in an earlier version. I'm too embarrassed to...

But I don't want to "consult the oracle"... I want to consult the SQL Server. *rimshot* :rolleyes:

RonKyle (6/5/2015)

---

I agree that that's a better way. It's been on my list to do for...

This is completely branching off the topic of the original article, but... I've grown accustomed to instantiating a Tally table whenever possible in any database I work with regularly, instead...

Alan.B (6/5/2015)

---

RonKyle (6/5/2015)

---

I like this caveat, especially as it now excuses my one use I have for looping...

To add to what qbrt is (I think rightly) pointing out, you can check ERROR_NUMBER() in your CATCH block and if it is 50000, you'll know that you raised it....

Ha ha, well, you know, everyone has been pretty polite I think; and although...

Alan.B (6/1/2015)

---

Let me ask a follow-up question and please don't take this as argumentative (you make a good point regardless) you ever had to do a 10,000,000 row update on...

Alan.B (6/1/2015)

---

So here's what's the takeaway here? It's better for an update to run for several extra seconds to prevent a several hundred ms blip for a single user? Rhetorical...

This also got me thinking of another real-world example I've faced. Let's say you have a third-party product that includes a really complicated stored procedure that does a lot of...

Brian J. Parker (6/1/2015)

---

Or did you mean...

g.britton (6/1/2015)

---

I think you've proved the main point. Using a CURSOR is usually the wrong way to go. Now, if it's decreasing the impact on other users, that's...

Of course, after all my work, I realize the response to my crude example might be:

update dbo.foobar with (rowlock) set foo = foo - 1

Alan.B (6/1/2015)

---

Until someone, anyone, can post an example where a cursor or other iterative method was faster than a...