Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,876 through 43,890 (of 59,097 total)

RE: Improving data import performance - More RAM ?

ifila (5/6/2009)
I still get nulls in the Account Table 🙁
Thanks
Are all of the files you're trying to import in the exact same format and field order?
--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)

May 6, 2009 at 5:32 pm

#990069
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

JohnG (5/4/2009)
To satisfy Jeff's curiosity...
Thanks, John.
About a year ago, I figure out how to make a strip function that manufactured the Tally table on the fly much as...
--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)

May 5, 2009 at 9:43 pm

#989326
RE: Performance issue with tally solution

peter (5/4/2009)
Here is an update to my tally function, it has now slightly less overhead by eliminating two cross joins.
As you keenly observed before, all of these are now 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)

May 5, 2009 at 9:32 pm

#989323
RE: "tempdb" size -- 550GB!

Sorry... my bad... looking for a ROWCOUNT > 1,000,000 won't count the internal rows generated as is so typical of a cross join. Perhaps just setting the duration to...
--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)

May 5, 2009 at 7:04 pm

#989300
RE: "tempdb" size -- 550GB!

Nah... that should do it. Just make sure that "TextData" is one of the columns returned so you can see the actual offending SQL. Since you're not interested...
--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)

May 5, 2009 at 6:54 pm

#989297
RE: UPDATE column with auto number depending on field value ?!

m.berggren (5/5/2009)
Jeff:
I think youré right. I think it has something to with clustered index on the table.
// Magnus
It absolutely does... UPDATE will update the data in the order of 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)

May 5, 2009 at 6:04 pm

#989289
RE: Filtered index with IS NULL predicate

Thanks for the info folks. Learned something new which is always a pleasure. I was just going for the "old doctor" trick. You know the one... go...
--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)

May 5, 2009 at 5:59 pm

#989288
RE: Improving data import performance - More RAM ?

ifila (5/5/2009)
I now have to find a parsing solution.
Thanks
The numbers I quoted included parsing. Lookup BULK INSERT in Books Online... you'll see. 🙂
--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)

May 5, 2009 at 5:52 pm

#989285
RE: Error string: Class not registered

Very interesting link, Jason. Sounds like my installation is pretty much hosed and there's nothing I can do about it because they moved my servers to a different State...
--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)

May 5, 2009 at 5:47 pm

#989283
RE: Are the posted questions getting worse?

Grant Fritchey (5/5/2009)
RBarryYoung (5/5/2009)
Alvin Ramard (5/5/2009)
David Burrows (5/5/2009)
Then you have those that would bite the hand that is trying to feed them.
Lucky for the OP that is was not Jeff,...
--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)

May 5, 2009 at 5:18 pm

#989274
RE: Are the posted questions getting worse?

Grant Fritchey (5/5/2009)
RBarryYoung (5/5/2009)
Alvin Ramard (5/5/2009)
David Burrows (5/5/2009)
Then you have those that would bite the hand that is trying to feed them.
Lucky for the OP that is was not Jeff,...
--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)

May 5, 2009 at 5:10 pm

#989273
RE: Give me a strong Solution?

Oh... and my definition of "Performance Tuning" is one of two things... either writing code to let the optimizer do its job, or rewriting someone else's code to let 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)

May 4, 2009 at 11:04 pm

#988551
RE: Give me a strong Solution?

The basic idea is to allow the optimizer to do it's job using properly written set based code. You do that by avoiding cursors and while loops in 99.99%...
--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)

May 4, 2009 at 11:02 pm

#988549
RE: Filtered index with IS NULL predicate

GilaMonster (5/4/2009)
No, it is covering and the optimiser should, theoretically, be picking it. Might be a bug, might be something subtle that we've missed.
I'm not sure how creating a filtered...
--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)

May 4, 2009 at 10:23 pm

#988536
RE: Do You Need an IT or CS Degree to be a Successful DBA?

I'd like to know why anyone cares? Either the DBA is doing (or can do) a good job or not. When I conduct an interview for a potential...
--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)

May 4, 2009 at 10:07 pm

#988535

Viewing 15 posts - 43,876 through 43,890 (of 59,097 total)