Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,886 through 36,900 (of 59,072 total)

RE: Question: float display as character

Sharon S (9/9/2010)
I see it now - thx again...
You bet... thanks 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)

September 10, 2010 at 5:25 am

#1219088
RE: Are the posted questions getting worse?

jcrawf02 (9/9/2010)
Jason, dialed into the S3oLV meeting tonight, absolutely phenomenal stuff from Stacia Misner on PowerPivot. Are all the meetings like that? 😉 Think I asked more questions over LiveMeeting...
--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)

September 10, 2010 at 5:19 am

#1219083
RE: Calling a UDF

vani_r14 (9/9/2010)
Hi all
Thanks for all your help in the Forum 🙂
I got it figured out and its working now... If any one needs it in case here is what...
--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)

September 10, 2010 at 5:00 am

#1219075
RE: Calling a UDF

vani_r14 (9/8/2010)[hrI have a function called Split and i would like to know - If can call that function in the where clause of Select Statement. This is a Table...
--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)

September 10, 2010 at 4:55 am

#1219074
RE: Poor performance when all RAM allocated, but not in use

hirro (9/9/2010)
Why does SQL crawl when I set it to be able to use all RAM in the system?
I've not done a deep dive on what's actually going on but...
--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)

September 10, 2010 at 4:44 am

#1219071
RE: Summed Daily totals giving different amounts from Monthly totals

It's likely anything BUT a rounding error. Simple addition or SUMming doesn't produce rounding errors unless the data has something like 4 decimal places and you're only calculating with...
--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)

September 10, 2010 at 4:36 am

#1219067
RE: saving a date to a varchar field as YYYY-MM-DD

Ok everyone... please let the OP answer for himself...
Dave,
It's normally a serious mistake when someone wants to convert a DATETIME to any type of character based output... why do you...
--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)

September 10, 2010 at 4:27 am

#1219063
RE: saving a date to a varchar field as YYYY-MM-DD

Chris Morris-439714 (9/10/2010)
Alvin Ramard (9/9/2010)
Jeff Moden (9/9/2010)
dave-dj (9/9/2010)
wow. Thanks for all the quick responses!. That's perfect thank you.
As always the ladies and gents of sqlserver central have been a...
--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)

September 10, 2010 at 4:25 am

#1219060
RE: saving a date to a varchar field as YYYY-MM-DD

Alvin Ramard (9/9/2010)
Jeff Moden (9/9/2010)
dave-dj (9/9/2010)
wow. Thanks for all the quick responses!. That's perfect thank you.
As always the ladies and gents of sqlserver central have been a great help.!
Everyday...
--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)

September 10, 2010 at 4:24 am

#1219058
RE: saving a date to a varchar field as YYYY-MM-DD

dave-dj (9/9/2010)
wow. Thanks for all the quick responses!. That's perfect thank you.
As always the ladies and gents of sqlserver central have been a great help.!
Everyday is a school day...............:-D
Let...
--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)

September 9, 2010 at 8:25 pm

#1218985
RE: This is SSC related actually

WayneS (9/8/2010)
But how do you like the one I decided not to use?
It was bloody fine. 😉
--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)

September 9, 2010 at 6:52 pm

#1218979
RE: Transform Data / Duplicate Records on the Fly

david.c.holley (9/9/2010)
I just ran across your article on Tally Tables and I don't know if I'm more surprised over the technique or that I nearly, mostly, sorta comprehend it. Its...
--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)

September 9, 2010 at 6:50 pm

#1218978
RE: Single huge view or mutiple smaller views

I tend to use "Divide'n'Conquer' methods. Unfortunately, those methods rarely include views... just queries within stored procedures.
I also tend to avoid views with aggregates because people do some terrible...
--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)

September 9, 2010 at 4:30 pm

#1218959
RE: Are the posted questions getting worse?

... with the possible exception of Alvin's singing. 😛
--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)

September 9, 2010 at 3:48 pm

#1218944
RE: Are the posted questions getting worse?

Steve Jones - Editor (9/9/2010)
Jeff Moden (9/9/2010)
Steve Jones - Editor (9/9/2010)
I should know in Oct if I can come. I'd like to. Allen is typically my roommate at places like...
--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)

September 9, 2010 at 3:48 pm

#1218943

Viewing 15 posts - 36,886 through 36,900 (of 59,072 total)