Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,286 through 45,300 (of 59,101 total)

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
RE: SQL Function : Find ‘X’ Business Days in the Future

j (2/4/2009)
But perhaps you'll grant me this: For the situation outlined, where a modest client has a few dozen active contract records in play and wants their SLA deadlines...
--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:20 pm

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

Bob Hovious (2/4/2009)
It can be done without a computer, for that matter...
True enough, j, but then we wouldn't have jobs !! :w00t:
Seriously, the reason people make...
--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:14 pm

#938578
RE: SQL Server 2005 upgrade changes column order of tables.

rich.ramos (2/3/2009)
This is no longer an issue. The customer just informed me that the field order in their SQL 2000 database is the same as what they are seeing...
--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 8:40 pm

#938575
RE: Using trim with Join

benlatham (2/3/2009)
Sure I appreciate that and I would be interested to hear from others who have faced this situation and their approach to it.
First thing to clarify is that in...
--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 8:26 pm

#938574
RE: Calculating UnitPrice Discounts

You bet... thank you for the feedback.
--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 8:18 pm

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

idrees.butt (2/4/2009)
One thing that I wana specify is that it was my first post on this forum and I am happy to see that the views to this post 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)

February 4, 2009 at 8:01 pm

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

idrees.butt (2/3/2009)
Can you give a general, simple and very good example of how to do that shift? like an alternate way(column wise thinking) to what a normal person would 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)

February 4, 2009 at 7:52 pm

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

Doc (2/4/2009)
Hi all,
I just want to contribute with a couple of pictures I've found on the net 😀
Man, I hope that's a light sabre he has in his hand... 😉
--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 7:37 pm

#938566
RE: SQL or Oracle

Bruce W Cassidy (2/2/2009)
Are you the reason they put hierarchies into SQL? So you could quote yourself? Self-referential and all that... :cool:[/font]
BWAA-HAAA!! Think of it 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)

February 4, 2009 at 7:33 pm

#938565

Viewing 15 posts - 45,286 through 45,300 (of 59,101 total)