Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,466 through 48,480 (of 59,099 total)

RE: How to improve insert performance

Ray Mond (9/3/2008)
You could also check the growth rate that's set for your data and log files. If it's too small (e.g. in 10 MB increments), the insert will...
--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 3, 2008 at 5:02 pm

#866877
RE: Understanding Index defragmentation

GilaMonster (9/3/2008)
gcg_wilkinson (9/2/2008)
I've found that even if u defrag an index and the physical disk is fragmented, then the index will remain fragmented.
It shouldn't contribute to the logical fragmentation. That's...
--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 3, 2008 at 4:58 pm

#866874
RE: For Each Loop [Exec SQL Task, Send Mail]

olafdedig (9/3/2008)
SOLUTION:
Hello, Here is the solution I found to my problem:
For doing a task like sending html mail (built using a SQL script and a Script Task) the for...
--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 3, 2008 at 4:56 pm

#866873
RE: For Each Loop [Exec SQL Task, Send Mail]

Ummm... I'm not very smart about SSIS because I don't use it... I always use something else like BCP, etc.
That, not withstanding, I follow the logic of the flow you've...
--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 2, 2008 at 8:33 pm

#866317
RE: Cursor

Heh... you keep adding scope to the problem, Simon. Not a problem but it would be nice to know the whole problem at once. For example, where did...
--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 2, 2008 at 8:28 pm

#866316
RE: Debugger For SQL

Carl Federl (9/2/2008)
Jeff & GSquared:
Did either of you get a chance to perform any additional analysis ?
No, I sure haven't... my apologies. Have a new job with 1:10+ commute...
--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 2, 2008 at 7:58 pm

#866312
RE: How to improve insert performance

James Horsley (9/2/2008)
It may be better to have a different index as the clustered index - obviously this might hurt performance elsewhere so it would require testing and a lot...
--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 2, 2008 at 7:54 pm

#866310
RE: database and transaction logs on same drive?

Yeaup... but if you loose the disk where the log file is, you're still going to miss data regardless of backups.
--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 2, 2008 at 7:52 pm

#866309
RE: Delete File Without xp_cmdshell

Peso (9/2/2008)
A CLR procedure maybe?
Heh... better be limited to only the directory being worked on or you might as well open up xp_CmdShell.
--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 2, 2008 at 7:44 pm

#866307
RE: Problem with the text data column, variable

I'm pretty sure you don't need PATINDEX if you prewrap the string to be split in delimiters... please see the section titled "One Final "Split" Trick with the Tally...
--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 2, 2008 at 7:41 pm

#866306
RE: swap data between 3 fields?

The 96 columns you're talking about each identify a region id for a person... and, I imagine that you have some nulls on each row. To normalize the table,...
--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 2, 2008 at 7:31 pm

#866303
RE: Table Update

Thanks for the feedback...
--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 2, 2008 at 7:27 pm

#866302
RE: disabled component to install

kiran4tech (9/2/2008)
Thanks for the information Jeff
-Kiran
You bet... thank you for the feedback.
--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 2, 2008 at 7:24 pm

#866301
RE: export data of all table to RAW files

manish.jain (9/1/2008)
Hi,
Thanks for your reply,
At this stag i am dumb... i am looking for some other good solution.
Would you please suggest me any other good way?
Thanks
Manish Jain
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)

September 2, 2008 at 7:21 pm

#866300
RE: Understanding Index defragmentation

gcg_wilkinson (9/2/2008)
I've found that even if u defrag an index and the physical disk is fragmented, then the index will remain fragmented.
That would also be true. A disk defrag...
--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 2, 2008 at 7:14 pm

#866299

Viewing 15 posts - 48,466 through 48,480 (of 59,099 total)