Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,546 through 52,560 (of 59,072 total)

RE: At what size db does it make sense to split into multiple files?

Absolutely agree with that... that's what makes forums like this so interesting and useful... differing experiences and opinions...
By the way... We did run into the problem of "If 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 13, 2008 at 5:48 pm

#778160
RE: Favorite Book Quote

Heh.... it's ok Steve... we're all friends here... I don't know how to read either 😀
--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 13, 2008 at 5:11 pm

#778153
RE: At what size db does it make sense to split into multiple files?

Paul Randal (2/13/2008)
So, sometimes the only thing you can do is mess around with the physical setup to improve things.
What are you going to mess around with in the phsical...
--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 13, 2008 at 5:04 pm

#778152
RE: At what size db does it make sense to split into multiple files?

Tom Leykis (2/13/2008)
I think having proper code should be assumed. My original question was asked so that I can properly setup a new db and not worry about adding multiple...
--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 13, 2008 at 4:28 pm

#778147
RE: At what size db does it make sense to split into multiple files?

Christopher Ford (2/13/2008)
What if you can't fix the code?
I did mention fixing code in my post. But that's not what this topic was about. 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 13, 2008 at 4:02 pm

#778142
RE: How do I create a dates table with every possible date??

Nuts,
I always like to see what people have up their sleeves for date and other utility tables... would you mind generating/posting the CREATE statement for your date table and maybe...
--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 13, 2008 at 3:39 pm

#778134
RE: At what size db does it make sense to split into multiple files?

Heh... all of that good information to solve, what?... .5% of the total performance problem? The real problem associated with most performance problems has nothing to do with hardware...
--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 13, 2008 at 3:28 pm

#778131
RE: The Identity Debate

Ya gotta learn to do it right, Matt... when you're running and screaming from his/her office, it's his/her hair that you're supposed to have a handful of... not your own...
--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 13, 2008 at 2:42 pm

#778114
RE: Concatenate numbers to form a 7 digit string

Matt Miller (2/13/2008)
No offence taken - just setting the bar in case you decide to throw your hat in the ring....
Say - you're not mixing cold meds and nicotine cessation...
--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 13, 2008 at 2:40 pm

#778113
RE: Concatenate numbers to form a 7 digit string

Christian Buettner (2/13/2008)
If I am not totally off the road, this should give a more even distribution of values than the checksum method.
Actually, Matt and I beat the daylights...
--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 13, 2008 at 2:35 pm

#778111
RE: The Identity Debate

Heh... ya gotta admit, though... it was funny...
--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 13, 2008 at 12:13 pm

#778003
RE: Concatenate numbers to form a 7 digit string

Sorry guys... didn't mean any offense... today's cold medicine still hasn't worn off and it came out all wrong 😛
I guess what I really wanna know from Stricknyn, is 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 13, 2008 at 12:08 pm

#778001
RE: Concatenate numbers to form a 7 digit string

Chris,
Good one... Keep in mind that would be good for one row at a time (Rand is not random in a single query) and if the digit "0" were allowed......
--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 13, 2008 at 11:55 am

#777992
RE: Help with formating

About this time, I'm thinking we stop fighting city hall on formats and let something else do the formatting for us... and much nicer than we can make in raw...
--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 13, 2008 at 11:25 am

#777983
RE: The Identity Debate

Heh... I know how to solve all of this... put all data into a single Name/Value table... primary key will also be all foreign keys and covering indexes :P:):D:hehe:
--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 13, 2008 at 11:22 am

#777979

Viewing 15 posts - 52,546 through 52,560 (of 59,072 total)