Jeff Moden

Forum Replies Created

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

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
RE: Hidden RBAR: Triangular Joins

LeeBear35 (2/3/2009)
I'm sure however that they will bring in consultants to address the issues, because that funding comes out of a different bucket.
There is nothing that says you couldn't become...
--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:18 pm

#938563
RE: Difference between varchar(max) and varchar(8000)

charlesz (2/3/2009)
The contents of Varchar(MAX), NVarchar(MAX), VarBinary(MAX), and XML fields are encoded using "Partially Length-Prefixed" (PLP in short). A PLP stream starts with total length (8 bytes), followed by current...
--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:11 pm

#938561
RE: Difference between varchar(max) and varchar(8000)

Lynn Pettis (2/4/2009)
(whispering..) I see high velocity pork chops....
(whispering wilst loading the pork chop cannon) C'mon target... stand up again... 😉
--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:07 pm

#938560
RE: Difference between varchar(max) and varchar(8000)

J (2/4/2009)
Sounds like the beginning of a flame war.
Let's keep our cool here.
Regards
It's hard to keep cool when some forum spammer posts bum information, says that an intelligent member 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 7:04 pm

#938559
RE: count of consecutive value

steve dassin (2/4/2009)
I appreciate your insight...when are you going to dive into Dataphor? 🙂
In all likely hood, never. Not because I don't think it's worthwhile or anything like 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 4, 2009 at 6:49 pm

#938556
RE: tempdb - Restricted File Growth option

Colin Lam (2/2/2009)
Jeff
How do you go about shrinking the tempdb through the GUI?
We don't know exactly what is causing the tempdb to grow so big, what we do know alot...
--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 6:25 pm

#938553

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