Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,791 through 38,805 (of 59,102 total)

RE: When not to use a temporary table?

Here's an example of why I say it's not the 20 million rows nor TempDB that's the problem. The following code generates 20 million orws of ID's just 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)

April 22, 2010 at 3:12 pm

#1156464
RE: When not to use a temporary table?

Dan.Humphries (4/22/2010)
With all respect
How would writing 20 Million rows to a temp table not be part of the problem even with the for-mentioned query problems. I would be very surprised...
--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)

April 22, 2010 at 2:41 pm

#1156437
RE: TempDB data file & Log file size

A couple of other folks and I recently discovered a possible problem with the IDENTITY function when used with SELECT/INTO in the form of explosive log file growth even 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)

April 22, 2010 at 2:15 pm

#1156424
RE: What Do We Want?

I wish they'd actually stop listening to most customers. Asking for things like enhancements to cursors just don't make sense to me. If they made things like PIVOT...
--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)

April 22, 2010 at 2:03 pm

#1156419
RE: When not to use a temporary table?

In fact, the LIKE's are a "hack" for doing a lookup on space delimited data. If you want this to fly, that space delimited data should probably be normalized....
--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)

April 22, 2010 at 1:57 pm

#1156411
RE: When not to use a temporary table?

The LIKEs will also kill performance because they have a wwildcard on each side. It's not the temp table that's your problem.
--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)

April 22, 2010 at 1:51 pm

#1156407
RE: No One is Safe

Michael Valentine Jones (4/22/2010)
Steve Jones - Editor (4/22/2010)
Or hope we have good backups! :w00t::hehe:
Please don't try that Michael. I suspect there are holes in what my devs built
I won't, I...
--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)

April 22, 2010 at 1:26 pm

#1156397
RE: Centrally located stored procs?

John Rowan (4/22/2010)
I'm with Steve here. This is a change management issue. I would develop a process to deliver the SP changes to your client DBs.
I definitely agree...
--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)

April 22, 2010 at 1:06 pm

#1156386
RE: Centrally located stored procs?

Lowell (4/20/2010)
bagofbirds-767347 (4/20/2010)
thanks. i do indeed use central functions for things like string/date operations. But my problem is getting the procs to work with data in the correct...
--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)

April 22, 2010 at 12:07 pm

#1156352
RE: MCJ - The Missing Link

Jason,
I thought you had it but I just sent you my email address, just to be sure.
--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)

April 22, 2010 at 10:23 am

#1156286
RE: Substring Function in Where Clause

eseosaoregie (4/22/2010)
There are rows which do not contain the 3 letter character representation of a week day at characters 2 through 4. They are:
'[Spreadsheet Extractor Big Block Allocs --...
--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)

April 22, 2010 at 9:48 am

#1156243
RE: Substring Function in Where Clause

Ah... almost forgot... I also need to know how many rows are in the staging table that you've been testing with and how long the split runs have been.
--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)

April 22, 2010 at 6:42 am

#1156042
RE: Substring Function in Where Clause

bc_ (4/21/2010)
try:
comp_column IN ('mon ','tue ','wed ','thu ','fri ','sat ','sun ')
Why? comp_column only contains 3 characters according to the OP's posted code.
--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)

April 22, 2010 at 6:40 am

#1156038
RE: Substring Function in Where Clause

eseosaoregie (4/21/2010)
I have now added sample data along with all the code for tables and indexes etc. Hopefully this will make things clearer
---tables
CREATE TABLE [stg_LogFiles] (
...
--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)

April 22, 2010 at 6:30 am

#1156026
RE: A DBA's Daily routine (and other items...)

Heh... move your chair into his cube and tell him you'll leave when he's taught you to know as much as him. Be sure to let your deoderant fail....
--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)

April 21, 2010 at 4:35 pm

#1155759

Viewing 15 posts - 38,791 through 38,805 (of 59,102 total)