Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,056 through 50,070 (of 59,099 total)

RE: datetime-typed column insertion conflict

Correct... the DATETIME datatype has a resolution of 3.3 milliseconds.
--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)

June 13, 2008 at 9:31 pm

#828868
RE: Update closest 3 stores based on stored procedure result

I'd sure be willing to try if you'd post your distance function, the CREATE TABLE statements for the two tables, and attach the data for all 25 stores and 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)

June 13, 2008 at 9:25 pm

#828867
RE: Load selected data from .txt file

sharma (6/13/2008)
I am loading data from .txt file with selected column only. (4 fields out of 40 fields)
I had created a .fmt file
It shows error as invalid column number.
How...
--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)

June 13, 2008 at 9:02 pm

#828866
RE: FLOAT to DATETIME

It might be a little bit slower than a whole bunch of math, but it sure is simple thanks to STR...
DECLARE @FloatDateTime FLOAT
SET @FloatDateTime = 20080613023001...
--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)

June 13, 2008 at 8:53 pm

#828865
RE: 100 GB database

I wouldn't worry about how long it takes to create the initial space. The important part is that you create as large a piece as you think you'll need...
--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)

June 13, 2008 at 8:25 pm

#828864
RE: how to convert vertical columns to horizontal

It's one of the most frequently asked questions, ever... 😉
--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)

June 13, 2008 at 8:18 pm

#828863
RE: Set based alternative of cursors?

Basically, you cannot convert it into true setbased code. Sure, you can probably get rid of all the looping by concatenating all of the commands into one huge variable...
--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)

June 13, 2008 at 8:13 pm

#828862
RE: Eliminating Cursors

Thanks for the feedback, Kevin... and thanks for the code you posted. There are only a few people who will take the time to actually do performance tests never...
--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)

June 13, 2008 at 7:41 pm

#828860
RE: Eliminating Cursors

Kevin Rathgeber (6/13/2008)
So using more real world scenarios, the while always seems to win out though not by much.
Jeff, does this seem right to you?
I'd pretty much agree depending on...
--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)

June 13, 2008 at 6:49 pm

#828858
RE: Eliminating Cursors

Ok... lemme demonstrate a couple of things... first, we need some data that everyone
can use and we need lot's of it because these tests run so darned fast. ...
--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)

June 13, 2008 at 6:14 pm

#828856
RE: Eliminating Cursors

Well, welcome aboard, Kevin! "Set-based" is nothing more than processing sets of information instead of processing "Row By Agonizing Row" (other wise known as "RBAR"... see my tag line...
--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)

June 13, 2008 at 2:46 pm

#828814
RE: Eliminating Cursors

Outstanding, Kevin! Thanks for posting the code.
Yep, Matt was right... One test is worth a thousand words... let the "test off" begin. To make it easier 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)

June 13, 2008 at 2:24 pm

#828802
RE: Eliminating Cursors

jcrawf02 (6/13/2008)
Is a 'test-off' like a 'dance-off'? should I go get some cardboard?
Only if you want to save the big pieces... 😀
--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)

June 13, 2008 at 1:53 pm

#828787
RE: Eliminating Cursors

Matt Miller (6/13/2008)
Edit: I see Jeff has already thrown the gauntlet:)
Yep... getting ready to launch some pork chops! 😉
--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)

June 13, 2008 at 1:47 pm

#828781
RE: Eliminating Cursors

Kevin Rathgeber (6/13/2008)
Good point on the SQL 2000 vs SQL 2005. My first attempt was against 2005. I tried again against a sql 2000 database and came out...
--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)

June 13, 2008 at 1:37 pm

#828772

Viewing 15 posts - 50,056 through 50,070 (of 59,099 total)