RBarryYoung

Forum Replies Created

Viewing 15 posts - 2,911 through 2,925 (of 7,636 total)

RE: Multi Column Sort

Peso (4/14/2009)
It's OK! Don't worry.
I have nothing to do besides awaiting the results from Adam's competition.
Heh, yeah. The day after the entry period closed for Adam's contest, I found...

April 14, 2009 at 1:48 pm

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

JKSQL (4/14/2009)
I am also looking forward to part due. I really try not to use cursors, but sometimes get in traps where I can not think of a better...

April 14, 2009 at 1:34 pm

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

Manie Verster (4/14/2009)
...
RJ, I hope you don't mind but I'm going to jump in here. Barry, maybe RJ's requirements is small enough to justify a distribution list but every year...

April 14, 2009 at 1:33 pm

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

GSquared (4/14/2009)
Not that another vote of confidence is needed, but I'm going to add one anyway. Good intro to the subject, Barry. Certainly a lot less dry than...

April 14, 2009 at 1:28 pm

#977588
RE: Using xp_cmdshell

OK Krusna, thanks for the detailed reply, it was very helpful.
Currently, my suspicion is that either the "PDF Printer" settings as user specific and have not been set for whatever...

April 14, 2009 at 1:24 pm

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

longobardia (4/14/2009)
RBarryYoung (4/14/2009)...
OK, I went back and re-read my article and I think I know what you are getinng at here. and yes, there are two mistakes in the...

April 14, 2009 at 12:37 pm

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

RBarryYoung (4/14/2009)
neufeldb4 (4/13/2009)
Allow me to make some observations.
...
This is the type of problem I have seen in 100% of the articles like yours that claim the cursor is a thing...

April 14, 2009 at 11:58 am

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

Lynn Pettis (4/14/2009)
I know I'm late adding this Barry, but I have to admit that I was right. During The Rant, Steve sent me a PM asking me to...

April 14, 2009 at 11:48 am

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

ManyHats11 (4/14/2009)
I thoroughly enjoyed reading this. I do use cursors when I get stuck and I'm anxious to see if I am able to pick up any new ticks.
Thanks, I...

April 14, 2009 at 11:36 am

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

Jerome Grimmer (4/14/2009)
Since cursors are so "evil", I would like to see someone write sql that will send emails to a table of users. Each user should receive a...

April 14, 2009 at 11:27 am

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

steve (4/14/2009)
OK, the issue is simply one of coding style for the most part. The optimizer should handle "declarative" code [whatever that is] in much the same way that it...

April 14, 2009 at 11:22 am

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

Dallas Martin (4/14/2009)
This code is considerably faster:
Declare @X int
Set @X = 0
Select @X = @X + 1
From master.sys.columns c1
Cross Join master.sys.columns c2
Print @X
Great example, Dallas!

April 14, 2009 at 11:18 am

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

WayneS (4/14/2009)
Thanks for the great article.
I also am waiting for the rest of this series. Hopefully, the wait is just daily.
...
Thanks, Wayne, but I am no Steve Jones! The...

April 14, 2009 at 11:17 am

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

john.danley (4/14/2009)
Thanks sushila for your comments so I don't have to. I agree with what you said.
I enjoyed the article and am looking forward to seeing the set based...

April 14, 2009 at 11:15 am

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

dbishop (4/14/2009)
I must say that for an introduction you did an okay job. The only thing I took offense of was the procedural vs. declarative examples and your definition of...

April 14, 2009 at 11:11 am

#977452

Viewing 15 posts - 2,911 through 2,925 (of 7,636 total)