Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,761 through 47,775 (of 59,095 total)

RE: Import CSV data into a table in SQL Server 2005 CE

You're trying to reinvent the wheel. 🙂 Use BCP or Bulk Insert, instead.
--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)

October 13, 2008 at 8:02 pm

#884391
RE: Assigning current of _Cursor to local @variable

This is a "simple" :hehe: "running total" problem except instead of a running total that carries the previous balance of each row forward, we'll just carry the previous 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)

October 13, 2008 at 7:57 pm

#884390
RE: Assigning current of _Cursor to local @variable

rgillings (10/13/2008)
I wouldn't feel right if I didn't offer a non-cursor alternative.
Heh... it's still RBAR on steroids, though. A cursor with Forward Only Read Only will be just 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)

October 13, 2008 at 7:45 pm

#884387
RE: db size grow when using index defrag-HELP!!

I believe you can add something like "Sort In TempDB" to your commands and only TempDB will change size, then. Lookup the reindexing commands you're using in Books Online...
--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)

October 13, 2008 at 7:35 pm

#884386
RE: Convert rows into columns

Shree (10/13/2008)
Hi, do you think can we write without the XML?
Yep... see the following article...
http://www.sqlservercentral.com/articles/Test+Data/61572/
Also, the folks in charge of the database have made a bloody huge error in not...
--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)

October 13, 2008 at 7:27 pm

#884385
RE: To get rows in CSV format

See the following for a basic "how to" and some pitfalls to avoid...
http://www.sqlservercentral.com/articles/Test+Data/61572/
... and, in most cases, the biggest pitfall is the task itself. CSV data shouldn't be stored...
--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)

October 13, 2008 at 7:16 pm

#884384
RE: Loading column having $ sign to SQL Server Destination

Greg Charles (10/13/2008)
The dollar sign isn't stored in SQL Server. If you need to display the money columns with the symbol, it should be applied in the application.
Heh... true...
--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)

October 13, 2008 at 7:13 pm

#884383
RE: Dangers of using MYSQL...What are they?

DBADave (9/23/2008)
Sounds like our DBA team won't be able to offer any arguments against it.
Thanks for the quick response.
Dave
Actually there is an argument against it. ...
--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)

October 13, 2008 at 7:00 pm

#884381
RE: Using Column Values from Table to Query Another Table

Heh... well, let's get sneaky, then...
DECLARE @Insert VARCHAR(MAX), @Select VARCHAR(MAX)
SET @Insert = ' INSERT INTO NewTable '
SELECT @Select = COALESCE(@Select + ' UNION 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)

October 13, 2008 at 6:48 pm

#884379
RE: SQL Server 2000 developer edition?

Correct... it isn't free. It only consts about $50, though. And, if you get caught using it on a production box, big fines are possible/probable.
--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)

October 13, 2008 at 4:00 pm

#884353
RE: Returning all rows with Split function

You bet... 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)

October 13, 2008 at 3:38 pm

#884350
RE: Return all rows where one is a match

Garadin (10/13/2008)
I think we're gonna have to run this on significantly more data, and with varying population of the records returned by the subquery to really examine this... although I...
--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)

October 13, 2008 at 9:36 am

#884236
RE: Return all rows where one is a match

Not a good thing to do... the Percentage of Batch is highly unreliable and frequently absolutely incorrect...
Look at the Percentage of Batch on the following code... then run it... SURPRISE!...
--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)

October 13, 2008 at 9:09 am

#884204
RE: Delete Duplicate values

Kenney Hill (10/11/2008)
Thank you Jeff.
And thanks for pointing out the RBAR aspect of recursive queries. I'm still not very good at spotting hidden RBAR, and you are the master...
--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)

October 13, 2008 at 8:34 am

#884178
RE: Return all rows where one is a match

Garadin (10/12/2008)
The execution plans are the same, but the percentages skew slightly. The join query has 235 reads as opposed to 156 for the IN. Unfortunately the dataset...
--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)

October 13, 2008 at 8:26 am

#884169

Viewing 15 posts - 47,761 through 47,775 (of 59,095 total)