Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,366 through 52,380 (of 59,072 total)

RE: Retriving data IN SQL SERVER 2000

bosekolli (2/23/2008)
my name is BABU i have requirement like this any body can help me?
i have a table name emp with 10000 records and without identity column i want first...
--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)

February 23, 2008 at 11:17 pm

#781412
RE: Export Data to Excel

The info in the following article should do it for ya...
http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/
--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)

February 23, 2008 at 11:09 pm

#781411
RE: Looking for Best Practice on Loading Flat File with 2134 columns

Marvin, that's just amazing to me... a data file that has more columns than rows... I don't believe I've ever seen such a thing except maybe for a single row...
--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)

February 23, 2008 at 6:07 pm

#781400
RE: Performance problem... how can I prevent it?

Thanks, Johan,
I took a look at the forced parameterization thing... looks real spooky when they say things like it could slow down the whole world and use with great caution,...
--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)

February 23, 2008 at 5:16 pm

#781395
RE: Looking for Best Practice on Loading Flat File with 2134 columns

Hoo boy... I understand... 2,134 columns of CSV data is enough to make anyone cranky.
How "clean" is the input file? Any problems with missing delimiters, etc?
--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)

February 23, 2008 at 12:59 pm

#781382
RE: Performance problem... how can I prevent it?

Ok folks... the statement level OPTION (RECOMPILE) that Matt spoke of really did the trick both on this current problem and the previous problems I had. Estimated execution plan...
--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)

February 23, 2008 at 12:44 pm

#781381
RE: Performance problem... how can I prevent it?

Jeff Moden (2/23/2008)
matt stockham (2/23/2008)
Gail is right on the mark. I wouldn't necessarily recommend "optimize for" though - you can use statement level recompile (new in 2005) to get...
--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)

February 23, 2008 at 11:22 am

#781375
RE: Performance problem... how can I prevent it?

GilaMonster (2/23/2008)
It's caused by the same thing. When the optimiser gets a query, it knows the value of any parameters (stored proc, auto parameterisation, or sp_executeSQL) and the value 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)

February 23, 2008 at 11:15 am

#781374
RE: Performance problem... how can I prevent it?

matt stockham (2/23/2008)
Gail is right on the mark. I wouldn't necessarily recommend "optimize for" though - you can use statement level recompile (new in 2005) to get the optional...
--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)

February 23, 2008 at 11:12 am

#781373
RE: Help - Production - The variable "User::SourcePath" doesn't contain file path(s).

Not 100% sure, but I think it's just a problem with permissions. What login is the agent using and does it have the privs to see the same directories...
--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)

February 22, 2008 at 8:59 pm

#781334
RE: Looking for Best Practice on Loading Flat File with 2134 columns

MD (2/22/2008)
I can't use bulk insert because of course the flat file does not match the table structure.
If you use a BCP format file, you can. 😉 See BOL...
--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)

February 22, 2008 at 8:45 pm

#781332
RE: Performance Tuning: Concatenation Functions and Some Tuning Myths

Thanks for the feedback guys...
Ryan and Mike C... thanks for the performance comparisons. That's good stuff. 😉
--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)

February 22, 2008 at 8:19 pm

#781330
RE: Performance problem... how can I prevent it?

Heh... sorry about that, Matt. Thanks for the help...
--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)

February 22, 2008 at 7:19 pm

#781328
RE: Performance problem... how can I prevent it?

Understood... but this doesn't even have anything to do with indexing... changing a constant to a variable causes a massively detrimental change in the execution plan. This is 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)

February 22, 2008 at 3:25 pm

#781291
RE: Performance problem... how can I prevent it?

Well, good! At least it's not just me! 😀 Thanks for the help, Matt and Michael.
I also ran into this the other night on something totally different...
--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)

February 22, 2008 at 1:29 pm

#781244

Viewing 15 posts - 52,366 through 52,380 (of 59,072 total)