Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,081 through 46,095 (of 59,101 total)

RE: Just For Fun: An Impossible Delete

RBarryYoung (1/7/2009)
Heh. I'm telling you, there's got to be at least a graduate thesis in Psychology or Communication on this. 🙂
What's really sad and spooky at the same...
--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 7, 2009 at 7:46 pm

#923046
RE: Tips for New DBAs

aprasy (1/6/2009)
Hi everyone,
I am sql developer. I studied ur article...
--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 7, 2009 at 7:37 pm

#923042
RE: Are the posted questions getting worse?

Steve Jones - Editor (1/7/2009)
Properly cut? Since when do those in MI know meat? Aren't you more the cheese and beer crowd with your neighbors?
BWAA-HAAA!!!! We know meat plenty...
--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 7, 2009 at 7:01 pm

#923032
RE: CDOSys and Identical code

BWAAAAA_HAAAAA-HAAAAA!!!!!! Oh shoot! I hate "nuances". I got it to work on all servers and I'm trying to figure out which of the differences between the old 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 7, 2009 at 4:34 pm

#922993
RE: CDO.Message.1The "SendUsing" configuration value is invalid.

Stacy (6/13/2006)
Borik,
I ran your code and received the error. After changing 'cdoSendUsingPort' & 'cdoBasic' to '2' & '1' respectively, the email was sent correctly. Do you know what values are...
--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 7, 2009 at 4:25 pm

#922991
RE: CDOSys and Identical code

Heh... OK... first of all, I'm not using DTS for any of this. Second, the SQL Server Agent, the Server itself, and I are all logging in as 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 7, 2009 at 3:10 pm

#922952
RE: CDOSys and Identical code

Sorry guys... looking at this stuff now... just got out of a really long meeting...
--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 7, 2009 at 1:39 pm

#922885
RE: CDOSys and Identical code

Gift Peddie (1/7/2009)
Yes Barry but those instructions are not correct for IIS6 which Jeff runs. The reason IIS6 comes not installed and smtp is a sub component of IIS...
--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 7, 2009 at 8:59 am

#922620
RE: CDOSys and Identical code

RBarryYoung (1/6/2009)
Found this reply to a virtually identical problem description:
Your in luck! I just figured this out last night. Go to Control Panel, add
remove programs, add remove windows components, find...
--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 7, 2009 at 8:24 am

#922575
RE: CDOSys and Identical code

Gift Peddie (1/6/2009)
Hi Jeff,
I found an alternative that uses stored proc that may be better than CDO I say may be because I have not used it.
http://msdn.microsoft.com/en-us/library/ms190307.aspx
Thanks, Gift.
--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 7, 2009 at 8:11 am

#922565
RE: Prduction DBA

PaulB (1/5/2009)
Always remember this: DBA owns the structure but never ever the data.
BWAA-HAAA! For me, anyway... that's not been true. Lose just one byte of data and see...
--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 7, 2009 at 5:11 am

#922439
RE: OLE Automation help

sperry (1/7/2009)
Hi again.
I didnt manage to get a response from anyone at simple talk. I have narrowed the problem down to security rights.
The account that we use...
--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 7, 2009 at 5:06 am

#922436
RE: Just For Fun: An Impossible Delete

windows_mss (1/7/2009)
IF object_id('tempdb..#tmpTBL') is not null
DROP TABLE #tmpTBL;
select distinct * into #tmpTBL from exampletable
truncate table exampletable
insert exampletable select * from #tmpTBL ORDER BY Name
drop table #tmpTBL
Yes... you 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 7, 2009 at 5:01 am

#922433
RE: CDOSys and Identical code

Thanks. Those are some pretty good links on the new stuff. Bad part about all the .Net stuff is that I really, really need this to run from...
--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 9:39 pm

#922311
RE: User Defined Function: order by won't work

tfifield (1/6/2009)
If all the data being fetched was in a covering index, would that guarantee the order?
Todd Fifield
Not with a SELECT. I've got a code example around here somewhere...
--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:51 pm

#922295

Viewing 15 posts - 46,081 through 46,095 (of 59,101 total)