That's why, if you look closely, you'll notice that I always capitalize "Cursor", unless I am specifically talking about those other benign (and usually hidden) cursors. For instance, these...

Jeff Moden (9/20/2008)

---

I agree, Barry... I used to call variables such as these "accumulators" which is also probably more appropriate.

"Pseudo Cursors"? That's certainly a correct description, but the word...

Wandrag (9/18/2008)

---

Whoa -this is cool....:)

Can you please explain how this works (Not the sp_refreshview part), but the fact that one don't have to loop through the view names to build...

I agree...

Heh indeed. 😛

Thanks and congratulations too!

I think that most of us are not doing it for the praise, but it is always nice to know when we are having a positive effect....

francis (9/19/2008)

---

Is there a way to kill certain users after hours for an application before doing backup ? Since when application is running, backup software refuses to continue. ...

You don't know the power of the darkside!

😀

Good point, but it is easy to fix this with...

I should also add that access to the above described service can be controlled through GRANTS to the individual users,.

In my experience, there are three different general things that you can use Service Broker for:

1. Asynchronous processing in response to events

2. Decoupling execution from a source caller

3. Implementing a...

Actually it's much easier than that and you don't need any evil Cursors either:

Declare @sql as NVarchar(MAX)

Set @sql = ''

Select @sql = @sql + 'EXEC sp_refreshview ''['

...

FWIW:

Microsoft encourages the use of the TOP clause in SQL 2005+ over the SET ROWCOUNT statement.

Steve Jones - Editor (9/18/2008)

---

Best you can, though most people have smaller environments and have to make guesses on performance. I would think the data size is the most important,...

Your other choice would be to bring it into a staging with a single NVarchar(MAX) per row, and then parse it from within SQL into Sparse column_set XML.