Jeff Moden

Forum Replies Created

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

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
RE: Compare Source Tables rows and destination Tables rows

Is there no way to simply do a COUNT(*) from each source and compare the two?
--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:11 pm

#866297
RE: Text file to sql server

Then, you have several choices. A couple of them include...
1. BCP the file in using a format file.
2. Import the entire width of a file into a...
--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 1, 2008 at 10:07 pm

#865822
RE: Text file to sql server

Also, what are the delimiters between columns in the files? If fixed field, what is the starting position and length of each column?
--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 1, 2008 at 8:51 pm

#865814
RE: disabled component to install

kiran4tech (9/1/2008)
I am trying to install sql server 2005 Enterprise edition
That would require that the machine you are installing it on be running WINDOWS SERVER. It's not gonna work....
--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 1, 2008 at 8:12 pm

#865811

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