Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,096 through 46,110 (of 59,101 total)

RE: CDOSys and Identical code

Thanks, Gift Peddie... You sure? I ask because both versions of the code run on all my servers but one and they're all Windows 2003 servers.
--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)

January 6, 2009 at 7:19 pm

#922292
RE: Proc does not execute but query does

Grant Fritchey (1/6/2009)
True. But those of whose who primarily live in OLTP land, recompiles are usually a problem, not usually a solution.
Dang it... I always forget about the other side...
--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)

January 6, 2009 at 7:13 pm

#922291
RE: Please help converting decimal (9) to string without decimals

foxjazz (1/6/2009)
dude, I don't know why the fool wants to convert it to a varchar, it's part of the requirement on the post.
He has his reasons, they aren't mine....
--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)

January 6, 2009 at 7:01 pm

#922288
RE: Temp tables vs. table variable speeds, temp tables faster???

Heh... "catch block"... that's another one... used properly, it's a great tool... but, for a huge number of the developers (using the term very loosly) I know, it's led to...
--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)

January 6, 2009 at 6:56 pm

#922287
RE: Alternatives to xp_cmdshell for Folder Directoy

Patrick Flynn (1/6/2009)
If the intention is to reduce or remove the use of extended stored procedures then replacing the xp_cmdshell with xp_DirTree is not really gaining much. However the xp_DirTree...
--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)

January 6, 2009 at 6:44 pm

#922286
RE: Are the posted questions getting worse?

Sent you an email with it, Lynn. Lemme know if you send something... seems like my spam filter has been eating everything in the world. Matt tried to...
--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)

January 6, 2009 at 6:37 pm

#922284
RE: Cursors Be Gone!

Heh... actually... we're all new here... I learn something new everyday.
Welcome aboard and happy Los Reyes.
--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)

January 6, 2009 at 6:26 pm

#922282
RE: Cursors for T-SQL Beginners

timothyawiseman (1/6/2009)
Jeff Moden (1/1/2009)
I believe that articles like this one serve as a great disservice to anyone new to databases and believe that it's horribly irresponsible of an author to...
--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)

January 6, 2009 at 6:22 pm

#922279
RE: CDOSys and Identical code

Heh... yeah, I've see that before... Funny and nasty all at the same time. 🙂
My concern is that those all say pretty much the same thing... either here's the...
--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)

January 6, 2009 at 6:13 pm

#922277
RE: T-Sql Script question to compare values between 2 tables

foxjazz (1/6/2009)
don't you guys have jobs?
Oh hell yes! I'm a professional pork chop launcher! 😛
--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)

January 6, 2009 at 6:06 pm

#922274
RE: CDOSys and Identical code

Oh yeah... meant to ask. Barry, do you remember what you did a search on? I did one on the error message itself and got just about everything...
--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)

January 6, 2009 at 4:15 pm

#922250
RE: CDOSys and Identical code

Heh... we're running Lotus Notes so not sure any of the servers are running Exchange. I'll take a look, though.
It would really be cool if Barry's suggestion were all...
--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)

January 6, 2009 at 4:14 pm

#922248
RE: Are the posted questions getting worse?

Properly cut pork chops only have 3 sides... well, until they hit... 🙂
--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)

January 6, 2009 at 4:07 pm

#922244
RE: Spatial Problem -- Polygons

Heh... it's the only way he could get the eyeholes on the helmet right. 😛
--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)

January 6, 2009 at 4:03 pm

#922243
RE: need a simple query

I agree... there's nothing in the data presented that identifies which row in the first table goes with which row in the second table other than physical order listed... 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)

January 6, 2009 at 3:57 pm

#922241

Viewing 15 posts - 46,096 through 46,110 (of 59,101 total)