Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,481 through 48,495 (of 59,102 total)

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
RE: more than one query in CASE-WHEN-THEN statement

Actually, using TOP 1 may b the worst suggestion... you don't care which value you get from the respective tables?
--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:09 pm

#865810
RE: Pass file name as variable

rohanverma (9/1/2008)
Yup, I got this from this forum:
declare @filename char(40);
set @filename = 'File1.txt'
declare @dir char(30);
set @dir = 'C:\Misc';
set @openrow1 = 'Driver={Microsoft Text Driver (*.txt; *.csv)}; DefaultDir=' + @dir + ';';
set...
--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:07 pm

#865808
RE: How do YOU use VIEWs?

mstjean (8/28/2008)
My argument against the usage I see here is that there are views nested within view within views. This is done to such an extent that what may appear...
--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 7:52 pm

#865807
RE: Update statement takes too long

The problem is that you've reached the undefined but omnipotent "tipping point". Try updating just a million rows and see how long (short) it takes. You'll need 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 1, 2008 at 7:46 pm

#865805
RE: Playing with "GO"

Heh... yeah... GO for it! 😛
No explanation should be necessary... try executing parts of it yourself... lookup GO in Books Online to see what its correct and only format is....
--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 7:43 pm

#865804
RE: How to write(insert) into database faster

You're using "bulkcopy" to do the inserts for "connections"? That's a new one on me. You're gonna have to show me that one. 🙂
The key is likely going...
--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 7:34 pm

#865803
RE: How to improve insert performance

When is the last time you did any maintenance on the indexes of 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 1, 2008 at 7:27 pm

#865800
RE: Compare two databases

Khalidhussain (9/24/2003)
I need to compare two databases (e.g. Development DB and Test DB) to make sure they are 100% identical. Is there a way to create a SQL view,...
--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 7:24 pm

#865799

Viewing 15 posts - 48,481 through 48,495 (of 59,102 total)