Jeff Moden

Forum Replies Created

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

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
RE: Difference between varchar(max) and varchar(8000)

charlesz (2/3/2009)
Sorry about my mistake. I should not trust document from Microsoft 100%. Here is a sentence from "Tabular Data Stream Protocol Specification".
"A type with unlimited max...
--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 5:28 am

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

idrees.butt (2/5/2009)
I am in the process of ordering the books online.
Don't bother... it comes free with SQL Server... it IS the "Help" system in SQL Server.
I will write the SP...
--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 5:13 am

#938731
RE: Top 1 or Max??

jcrawf02 (2/3/2009)
Grant Fritchey (2/2/2009)
I agree with Jeff, portable code is a myth.
Oh yeah??!! Well, what if I code on a laptop, huh? Huh?
Thought so.
😀
--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 4, 2009 at 9:50 pm

#938590
RE: SQL Function : Find ‘X’ Business Days in the Future

J... I've gotta say that you're taking all of this pretty well. It does take some effort to create an article and it does take a certain amount 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)

February 4, 2009 at 9:45 pm

#938589
RE: SQL Function : Find ‘X’ Business Days in the Future

j (2/4/2009)
Andrew Reilly (2/4/2009)
Another flaw with this solution is it doesn't handle adding a negative number of days which is just as important in my eyes
You are correct.
And in 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)

February 4, 2009 at 9:33 pm

#938586
RE: SQL Function : Find ‘X’ Business Days in the Future

Andrew Reilly (2/4/2009)
I did this without a loop using a recursive function...
I believe you'll find that most forms of recursion are actually slower than using a loop. Just because...
--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 4, 2009 at 9:28 pm

#938581

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