Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,561 through 52,575 (of 59,091 total)

RE: Help With Query

Aaron,
This should do it... also, take a look at how I created the test table and data... would help a lot if you could post sample data like 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 13, 2008 at 9:15 pm

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

Christopher Ford (2/13/2008)
Jeff, I could almost hug you actually...you wrote an article the other day that I have been working a problem for 6 months on trying to solve. ...
--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 8:50 pm

#778180
RE: Bulk insert question

Vika (2/4/2008)
OK you are right. It is not possible to bulk insert from the file into a table variable. It is possible to bulk insert from the file into 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)

February 13, 2008 at 6:27 pm

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

Tom Leykis (2/13/2008)
Ok, this will really light your fire :hehe:
The reason I was asking is becuase it's my database, for my company, that I manage the db for, because I'm...
--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:57 pm

#778162
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

Viewing 15 posts - 52,561 through 52,575 (of 59,091 total)