Eric M Russell (4/7/2015)

---

Geo-replication and geo-backups are two different things. Every cloud data vendor should have daily or weekly off-site backups that include even the lowest tier customers who arn't...

RonKyle (4/6/2015)

---

There's a lot of things that can happen, but these are all fringe examples, at least in the current political environment. You can't guard against everything, and if...

xsevensinzx (4/5/2015)

---

It's way too expensive for most companies to do that. It has too much risks in some cases. Even if you do take it on, the team has to...

It would be great if more companies used an apprenticeship approach, but that luxury isn't often available (usually because there is no manpower and no budget). It's a shame.

One...

How many records in...

I don't think it's a bug.

Both Select Count(*) and Select Count(1) would generate the same index scan as a Select *. I'd guess that the permission check is done...

s.greco (2/8/2015)

---

Hi, there are differences between engine sql server 2005 and 2008 to execute a stored procedure with a cursor, because I note execution times much faster with the 2005...

There was a post in these forums not long ago from a programmer who was new to an environment that had some rigid rules. Some of them actually dangerous...

j-1064772 (2/3/2015)

---

This article provides a good INTRODUCTION to a set-based method of eliminating "row-by-agonizing-row" (RBAR) cursor code but it is not the complete story. There is more information to consider...

h.tobisch (2/3/2015)

---

1. I never use static cursor but cursor variable

declare @C cursor

set @C...

Caruncles (2/3/2015)

---

Great and timely article. Using your search query I discovered we have 129 procs using cursors. However, I was hoping you would show code examples of the...

jyouq (2/3/2015)

---

Interesting article. But I wasn't too familiar with cursors, having only written 1 to solve an issue, so I had to hit the internet to see where/how to apply...

Yakov Shlafman (2/3/2015)

---

Briant,

thanks for the article.

I think the first snippet of the code should be like this:

WHILE @@FETCH_STATUS = 0

BEGIN ...

Sorry, didn't see that part of your post.

It's complaining about your SET =...

Homework?

Post what you have tried for your answer and we can give some pointers. It does you (and the industry) no good at all if we do...