Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,761 through 41,775 (of 59,067 total)

RE: Can't Import Data Fast Enough - Optimize or rethink the design?

winterminute (9/27/2009)
Hey Jeff, as always thanks for your advice.
Sounds like I need to create a new table with the right schema and move all the existing data into it 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)

September 27, 2009 at 7:36 pm

#1058888
RE: Increase data import performance

173 stored procedures? That just doesn't seem right somehow and it smacks of RBAR. How many rows do each of these stored procedures handle... one?
--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)

September 27, 2009 at 8:32 am

#1058841
RE: MDX to generate CSV file as Output

Dan English-729975 (9/26/2009)
...and then export to CSV.
I believe that's the crux of the original question... how would you do that without SSIS or SSRS, Dan?
--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)

September 27, 2009 at 8:28 am

#1058840
RE: SQL Server 2000 Related Query

What I'm concerned about is the apparent lack of detail in the requirements they gave you. I just can't imagine that they don't care about the sort order of...
--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)

September 27, 2009 at 8:01 am

#1058837
RE: how can we create a table snapshot?

I wasn't the one that set it up (our OPs guys set it up) so I don't know many of the details. The servers and the SAN were all...
--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)

September 27, 2009 at 7:39 am

#1058833
RE: Can't Import Data Fast Enough - Optimize or rethink the design?

You can certainly change the PK to an identity column and, if you can guarantee that duplicates across what is currently the PK will be keep out by process, then...
--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)

September 27, 2009 at 7:23 am

#1058832
RE: how can we create a table snapshot?

We never experienced such a thing... not even when the source or target when down for one reason or another. Maybe we just got lucky but it ran 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)

September 26, 2009 at 5:07 pm

#1058796
RE: Are the posted questions getting worse?

Bob Hovious 24601 (9/26/2009)
Makes sense.
Hope you didn't mind my taking pity on the OP who didn't have a clue about how to do a set-based...
--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)

September 26, 2009 at 5:03 pm

#1058795
RE: how can we create a table snapshot?

The thing I don't like about any form of SQL Server replication (it's been fixed in 2k8) is when you need to alter a table which it won't let you...
--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)

September 26, 2009 at 4:47 pm

#1058791
RE: Split String and ordering

Sorry, I'd forgotten to populate the Note_ID column in the Temp Table... I've added it to the code above.
--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)

September 26, 2009 at 4:41 pm

#1058789
RE: Split String and ordering

Heh... the only thing I know about XML is that it uses a fair bit of memory, clogs the pipe with extra data, and is relatively slow.
Give the following...
--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)

September 26, 2009 at 4:29 pm

#1058788
RE: Split String and ordering

jwhisman (9/26/2009)
Yes, the Note_ID is just the @NoteID value. According to the notes I have, it's because of how the report uses it as a parameter, so it needs...
--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)

September 26, 2009 at 3:23 pm

#1058784
RE: Split String and ordering

Ah! Got it! My apologies but that brings up one final question... can you mark up the following lines with what the NoteID should be, please? OR......
--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)

September 26, 2009 at 2:51 pm

#1058780
RE: Split String and ordering

Just one final thing and then I may have enough to go on... can you post the table creation statement for where the split data will be inserted into? ...
--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)

September 26, 2009 at 2:16 pm

#1058777
RE: Split String and ordering

Thanks. You can always attach longer data as a text file when you post (instead of listing it as part of the body of a post).
What I'm trying 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)

September 26, 2009 at 1:29 pm

#1058771

Viewing 15 posts - 41,761 through 41,775 (of 59,067 total)