Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,271 through 45,285 (of 59,101 total)

RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Jonathan Kehayias (2/6/2009)
Jeff Moden (2/6/2009)
Heh... listen to you... Anyone capable of writing either the CLR or the T-SQL isn't going to miss the sp_OADestroy. Anyone who doesn't understand enough...
--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)

February 6, 2009 at 10:51 pm

#939906
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Jonathan Kehayias (2/6/2009)
I didn't use his CLR method directly because it has an inherent flaw in its usage of Regex in it
that I wouldn't make in my own code....
--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)

February 6, 2009 at 10:36 pm

#939905
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Jonathan Kehayias (2/6/2009)
Ok, what did I miss?? I don't quite know what I missed? If it was the exception from providing a bad path... I didn't miss that,...
--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)

February 6, 2009 at 9:54 pm

#939898
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Don, here is a VERY good example on why CLR's sometimes ARE the way to go:
SQL Server CLR function to improve performance of validating email addresses
Lordy, here we...
--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)

February 6, 2009 at 9:19 pm

#939888
RE: dealing with timestamp

NGLN (2/5/2009)
Jean-François Bergeron (11/6/2008)
Simply add a where on the key
Maybe a silly question from this beginner, but is the following the right way then?
CREATE TRIGGER trTest_Update ON Test
AFTER...
--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)

February 6, 2009 at 5:49 pm

#939874
RE: Guest Editorial: Do DBAs Need a Code of Ethics?

Steve Jones - Editor (2/6/2009)
Wow, quiet a debate going on!
Brad, thanks for the break and a nice job on the editorial.
We all need to get "reset" at times, to have...
--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)

February 6, 2009 at 5:17 pm

#939869
RE: SQL or Oracle

I, on the other hand, hope that true relational databases never come to pass. The non-relational ones are a hell of a lot more fun. 😉
--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)

February 6, 2009 at 5:11 pm

#939867
RE: Changed to a StarWars Avatar...am I part of the Club now?

Grant Fritchey (2/6/2009)
tosscrosby (2/6/2009)
Not the BEST bounty hunter in the galaxy - was it a mutual agreement sort of thing? (now we're really getting wierd)
Union.
Heh... ok... now I'm really afraid...
--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)

February 6, 2009 at 5:09 pm

#939865
RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

idrees.butt (2/6/2009)
Then what should I buy? SQL Server? I dont have it! Dont go into details please...
I am confused now! I think I should buy the books online!
What on Earth...
--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)

February 6, 2009 at 5:05 pm

#939864
RE: how can i solve this problem?

Ramesh (2/6/2009)
Jeff Moden (2/6/2009)
Take another look guys... Ashy wants to return the rows that are second to the last for each account number... 😉
Actually, I can't read people's mind:D...Jeff, though,...
--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)

February 6, 2009 at 9:37 am

#939628
RE: Exec 2k5 proc from 2k DTS

Thanks for the confirmation, Mike. I appreciate 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)

February 6, 2009 at 8:21 am

#939564
RE: how can i solve this problem?

Take another look guys... Ashy wants to return the rows that are second to the last for each account number... 😉
--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)

February 6, 2009 at 8:18 am

#939563
RE: Guest Editorial: Do DBAs Need a Code of Ethics?

Ewan Hampson (2/5/2009)
Jeff Moden (2/5/2009)
The ironic part about this whole discussion is that a code of ethics would only be followed by ethical people. 😉
Not the point. Having...
--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)

February 5, 2009 at 12:32 pm

#939124
RE: Reclaim Unused Space in a Table

Jonathan Kehayias (2/5/2009)
Run DBCC UPDATEUSAGE on the database and check the free space for the database again.
Heh... in the spirit of what you told Paul, you should explain why 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)

February 5, 2009 at 9:31 am

#938972
RE: Guest Editorial: Do DBAs Need a Code of Ethics?

The ironic part about this whole discussion is that a code of ethics would only be followed by ethical people. 😉
--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)

February 5, 2009 at 9:12 am

#938949

Viewing 15 posts - 45,271 through 45,285 (of 59,101 total)