Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,916 through 36,930 (of 59,098 total)

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
RE: Transform Data / Duplicate Records on the Fly

david.c.holley (9/9/2010)
The underlying goal is NOT to expand the number of days - taking a start date of 9/1 with an end date of 9/15 and creating records for 9/2...
--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:42 pm

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

HowardW (9/9/2010)
Jeff Moden (9/9/2010)
Actually, expanding to individual days would cause a lot of overhead. There's a better way but you're definitely on the right track.
Good point - didn't consider...
--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:38 pm

#1218940
RE: Question: float display as character

Sharon S (9/9/2010)
Jeff and all,
Thanks for posting this response - it did the trick! SELECT UPPER(CONVERT(VARCHAR(30),@ReturnValue,2))
However, I don't understand why. Would you mind explaining if you have the time?
Thanks...
--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:35 pm

#1218938
RE: Linking to the Previous Row

Robert Carretta (9/9/2010)
David,
I have used Table Variables to accomplish the same thing. Are there a drawbacks to using table variables instead of CTEs? Are there advantages to using CTEs?
Table variables...
--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:32 pm

#1218936

Viewing 15 posts - 36,916 through 36,930 (of 59,098 total)