Jeff Moden

Forum Replies Created

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

RE: Enhancing the readability of your code: Table aliasing in sql

But in this particular SQL statement, there's no reason to alias your tables names - it would just save a few keystrokes, at the cost of making it much less...
--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 10:40 pm

#990125
RE: SET vs SELECT

aloj (5/6/2009)
SET is safer. Code below will throw an error. With select you will get a value from one of the records. Troubleshooting logic error caused by SELECT is more...
--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 10:01 pm

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

lcardwell (5/6/2009)
I spend a good deal of time 'splaining why certain processes/practices are important and getting folks to think 'out of the box'...
Heh... my most difficult task has been 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 6, 2009 at 9:22 pm

#990109
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Manie Verster (5/6/2009)
Maybe I have an old version but doesn't matter, use any table or any string fields. This works famously. I wonder where he got the tally table idea...
--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 7:28 pm

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

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