RBarryYoung

Forum Replies Created

Viewing 15 posts - 2,926 through 2,940 (of 7,636 total)

RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Lynn Pettis (4/14/2009)
There are several of us who would take on the challenge of attempting to rewrite a cursor based solution as a set based solution. If you take...

April 14, 2009 at 10:56 am

#977435
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Steve Rosenbach (4/14/2009)
...In fact, the title of this series inspired me to write new lyrics for the first verse of the great Paul Simon song - Barry, this is...

April 14, 2009 at 10:52 am

#977432
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Matt Whitfield (4/14/2009)
sushila (4/14/2009)
As for the instances where you use cursors and no one else would be able to "improve either performance or readability with their removal", I volunteer Jeff...

April 14, 2009 at 10:49 am

#977430
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Scott Solice (4/14/2009)
The article was excellent. It went a long way as an intro on the benefits of thinking set-based in SQL. The "technical" reasons were stated very clearly (eventually)....

April 14, 2009 at 10:48 am

#977428
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

bruce.trimpop (4/14/2009)
Well I'm no expert, but given the "forward only" nature of the example cursor, seems like it should be a"FAST_FORWARD" cursor to allow for performance optimizations. ...
Yikes! Excellent...

April 14, 2009 at 10:45 am

#977425
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

RJ (4/14/2009)
RBarryYoung,
I would like to see how you can eliminate using a CURSOR or WHILE loop for sending emails using "msdb.dbo.sp_send_dbmail". My requirement would be to send email notifications to...

April 14, 2009 at 10:31 am

#977408
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

gserdijn (4/14/2009)
select square(count(1)) From master.sys.columns C1
Heh, very nice. I think that you may have "cooked" my example!

April 14, 2009 at 10:20 am

#977399
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

sushila (4/14/2009)
...It's a tough job being able to communicate and get your point across - simplify it, but not to the point where it looks like you're talking to the...

April 14, 2009 at 10:18 am

#977393
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Manie Verster (4/14/2009)
...
Barry, when are you going to give us your comments on what is being said here?
Patience, Mannie. I've still got a job plus at least 6 hours...

April 14, 2009 at 10:12 am

#977389
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

longobardia (4/14/2009)
...
Now, I am no SQL Genius but I was able to formulate the following query based on the example:
select max(k.RowNum)
From (
select ROW_NUMBER() over (order by s.dta desc) as 'RowNum'
from...

April 14, 2009 at 10:10 am

#977384
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Gaby Abed (4/14/2009)
You're a brave man RBarryYoung. At least the comments here have been kinder than with the article I wrote (link omitted on purpose, still shellshocked, LOL)
Thanks, Gaby....

April 14, 2009 at 10:05 am

#977375
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

vinizio (4/14/2009)
I think Brad took it personal!!! This article is an opinion and it is up to us to discuss and bring our comments in how to improve the a...

April 14, 2009 at 10:03 am

#977370
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

rot (4/14/2009)
Good introduction! Looking forward to reading part 2 (+1).
And totally agree with Kev. I only want to add that nobody is asking anybody to fire their cursors if they...

April 14, 2009 at 10:01 am

#977369
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Anirban Paul (4/14/2009)
Very nice article and really well explained. I will also enjoy this series....
Thanks, Paul. That means a lot coming from you.

April 14, 2009 at 9:58 am

#977366
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

noxidjkram (4/14/2009)
Another vote for a well written introduction.
For all those experienced and insulted DBAs out there, please remember the up-and-comings like myself who really appreciate an introduction to the subject...

April 14, 2009 at 9:57 am

#977364

Viewing 15 posts - 2,926 through 2,940 (of 7,636 total)