Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,696 through 52,710 (of 59,072 total)

RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Philippe Cand (1/31/2008)
I will derail this conversation and give it another spin.
Wether or not something is supported by Microsoft does not make it safer.
It is all about probability and bugs....
--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)

January 31, 2008 at 9:36 pm

#774038
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

James Goodwin (1/31/2008)
Did you test using the Clustered Index with the ORDER BY subquery? It seems to me that the ORDER BY Would enforce the order, but since you...
--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)

January 31, 2008 at 9:21 pm

#774033
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

However, the engine has no obligation to scan the table in index order, as there are no language constructs which impose an ordering on the execution order of a scan....
--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)

January 31, 2008 at 9:11 pm

#774030
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Ian Yates (1/31/2008)
I have to agree with the naysayers unfortunately. It's great at the moment and really does seem to work (I haven't seen it fail yet either). ...
--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)

January 31, 2008 at 8:47 pm

#774028
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

ALZDBA (1/31/2008)
Very good article, nice testcode. :w00t::cool:
There may be some testing needed regarding parallelism,
maybe for now just add a OPTION(MAXDOP 1).
The only remarks I would add to the conclusion...
--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)

January 31, 2008 at 8:35 pm

#774027
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Christian Buettner (1/31/2008)
Hello Jeff,
very interesting article.
Somehow it throws all my beliefs into the trash bin:
1. The update method with variables is not explicitly supported by Microsoft
2. The clustered...
--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)

January 31, 2008 at 8:28 pm

#774026
RE: The January Car Update

According to a recent radio ad by one of the better known railways, freight trains use only 1 gallon of fuel to haul 1 ton (2,000 pounds) 443 miles... we...
--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)

January 30, 2008 at 10:48 pm

#773630
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

Yep... thanks for the feedback. I've seen that, too. But only on SELECTs... and only on non-clustered indexes. I've never seen it fail on UPDATEs on CLUSTERED...
--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)

January 30, 2008 at 10:41 pm

#773628
RE: Total columns in a table

Heh... don't forget about DBCC SHOWCONTIG WITH TABLERESULTS
--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)

January 30, 2008 at 3:58 pm

#773564
RE: ISQL ERROR..

Didn't you read any of the above? Don't use ISQL... use OSQL or SQLCMD depending on which version of SQL you have.
--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)

January 30, 2008 at 6:08 am

#773217
RE: The ARRAY In SQL Server 2000

bonk (1/29/2008)
Hi Jeff!
I agree with you! But there's nothing to do in this case. I explain: the table with one column for each month already exists and I can't modify...
--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)

January 30, 2008 at 5:59 am

#773212
RE: ISQL ERROR..

It's because ISQL is just a subset of what the server can actually do. Do NOT use ISQL. Use OSQL 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)

January 29, 2008 at 8:03 am

#772870
RE: Autogenerate dates

I agree with Matt... recursion is probably not the best way to do things like this...
There are variations on this theme but here's a nice little NON-recursive CTE that...
--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)

January 29, 2008 at 7:59 am

#772866
RE: Suppress column name output in BCP

It that case... might be OSQL... THAT does have such a set of switches... if memory serves, "-h-1" (no spaces, no quotes) would be the switch you're looking 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)

January 28, 2008 at 2:02 pm

#772644
RE: The ARRAY In SQL Server 2000

I would like to know how can I read a record from a table with 12 columns (each on for each month in a year) end put the value 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)

January 28, 2008 at 1:59 pm

#772642

Viewing 15 posts - 52,696 through 52,710 (of 59,072 total)