Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,756 through 37,770 (of 59,098 total)

RE: Are the posted questions getting worse?

WayneS (7/9/2010)
Jeff Moden (7/9/2010)
Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone has...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 9:19 pm

#1191103
RE: Are the posted questions getting worse?

Stefan Krzywicki (7/9/2010)
Jeff Moden (7/9/2010)
CirquedeSQLeil (7/9/2010)
Jeff Moden (7/9/2010)
Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate"...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 9:17 pm

#1191102
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/9/2010)
Jeff Moden (7/9/2010)
Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone has...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 8:26 pm

#1191093
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/9/2010)
The Dixie Flatline (7/9/2010)
Congrats, Jeff. I will bring a big bag of peanuts to your session so your SSC fans can throw them at you if you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 8:24 pm

#1191092
RE: Convert CSV values in three columns to rows

Jeff Moden (7/6/2010)
Thank you for the test harness and your good code, Oleg. I'll check it out.
Sorry, Oleg... I've not nbeen able to put in the time to do...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 7:29 pm

#1191088
RE: Are the posted questions getting worse?

Ah.... just found another email from Elena... the Tally Table session in "Approved" and the Hierarchy session has been labeled as an "Alternate" in case someone has a problem and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 4:30 pm

#1191061
RE: Are the posted questions getting worse?

Interesting... PASS accepted my abstract on the Tally Table session. I'm actually a bit surprised at that. I had also submitted an abstract on a new way...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 4:24 pm

#1191060
RE: Are the posted questions getting worse?

The Dixie Flatline (7/9/2010)
Jeff, you have hp on the brain.
You need to clean the cages out more often ,,, or naybe less often. 😛
Heh... of...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 4:18 pm

#1191058
RE: Try Catch alters behaviour of existing procedures

The Dixie Flatline (7/9/2010)
Double Forward Fourier Transforms ??
😛
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 4:16 pm

#1191057
RE: Best Approach To Enable and Allow Use xp_cmdshell Non sysAdmin Users

shoffman-569213 (7/8/2010)
The developers are using xp_cmdshell and the OS dir command to verify that the file path and file exists before loading the contents and doing further processing. Using...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 3:45 pm

#1191051
RE: Try Catch alters behaviour of existing procedures

doobya (7/8/2010)
If you don't mind, I'll just go ahead and disagree with you on all those points. 😉 It all works exactly as I expect it to work according...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 3:34 pm

#1191049
RE: Are the posted questions getting worse?

CirquedeSQLeil (7/9/2010)
Alvin will soon be making a christmas soon that involves flux capacitors, pork chops, and bears
Do forget the hampster poo... flux capacitor just isn't the same without it.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 9, 2010 at 3:22 pm

#1191043
RE: Try Catch alters behaviour of existing procedures

doobya (7/8/2010)
Thanks all for your comments
as long as the point is clear - mixing TRY with @@error can cause subtle problems
and this point is not made in BOL, breaking changes,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 8, 2010 at 6:17 am

#1190185
RE: Leanring from Experts

william-700725 (7/7/2010)
Jeff Moden (7/7/2010)
william-700725 (7/7/2010)
[font="Courier New"]Andy, one of the first lessons I learned in journalism is that, until you send your copy off to the typesetters, it's never to late...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 8, 2010 at 6:13 am

#1190181
RE: Best Approach To Enable and Allow Use xp_cmdshell Non sysAdmin Users

shoffman-569213 (7/7/2010)
I have some developers that are using xp_cmdshell and to get it to work I had to grant administer bulk operations for a network group. What does this...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 7, 2010 at 7:56 pm

#1189958

Viewing 15 posts - 37,756 through 37,770 (of 59,098 total)