Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,086 through 47,100 (of 59,101 total)

RE: The Joy of Numbers

Heh... dang it... I gotta remember... "Scroll Down". You have that in the code. :blush:
I'm running some tests on this (cuz it's interesting)... I'll give a complete report when...
--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)

November 22, 2008 at 9:17 am

#902030
RE: The Joy of Numbers

Sounds like a lot of fun... thanks for the feedback. Did you index the numbers table with a clustered PK by any chance?
--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)

November 21, 2008 at 7:24 pm

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

mstjean (11/21/2008)
*Wow*
I just found this article and cannot wait to run some tests and eventually try it out in prod. I've only read the first page of comments, so no...
--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)

November 21, 2008 at 7:14 pm

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

Jeff Moden (1/31/2008)
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...
--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)

November 21, 2008 at 7:10 pm

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

Christopher Ford (5/11/2008)
Anirban Paul (5/11/2008)
Abosolutely. What I like most about the discussions is that you can't just write 'casual' writing. You have to be absolutely sure about the content before...
--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)

November 21, 2008 at 5:48 pm

#901938
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

I'm of the same ilk... 🙂
Lemme know what you think when you've had a chance to run the code. Thanks.
--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)

November 21, 2008 at 5:31 pm

#901933
RE: Are the posted questions getting worse?

Heh... yeah... "Please Help"... I especially love the one's that have the word "URGENT!" in the title. Those are always "fun" in one form or another. Then, there's...
--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)

November 21, 2008 at 5:28 pm

#901932
RE: My application's response time has gone down from 20 sec to 2 sec after upgrading from SQL Server 2000 to SQL Server 2005.

Like I said... you got lucky. There have been dozens of posts where folks want to go back to 2k because 2k5 made the app slower.
Very glad it worked...
--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)

November 21, 2008 at 5:00 pm

#901926
RE: Select based on Date- How to?

Heh... then there are the folks that believe those datatypes are nothing more than a form of formatting that should really be done in the GUI. I'm one 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)

November 21, 2008 at 5:19 am

#901546
RE: My application's response time has gone down from 20 sec to 2 sec after upgrading from SQL Server 2000 to SQL Server 2005.

sandeephughes (11/21/2008)
Thanks for everybody's reply for confirming that SQL Server 2005 has much better performance improvement than SQL Server 2000.
Nah... that's just not true. It may be true 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)

November 21, 2008 at 5:14 am

#901543
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

Damned smiley faces... see attached, please...
--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)

November 20, 2008 at 9:25 pm

#901422
RE: Reading File attributes (datecreated,datemodified....) using sp_OACreate....

Well, kinda... 😉 It doesn't use xp_CmdShell, but it does (I'm a bit embarrassed but couldn't be helped with sp_OA* in SQL Server 2000, that I know of) use...
--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)

November 20, 2008 at 9:20 pm

#901421
RE: How to minimize processing time when using a cursor

Heh... yeah... I don't even look for the word CURSOR, anymore... they need a WHILE loop to really do anything and, since both are RBAR, I just look for the...
--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)

November 20, 2008 at 9:09 pm

#901415
RE: Displaying NULL as the last row + ORDER BY

Run the code... what do you think from running the code?
--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)

November 20, 2008 at 9:04 pm

#901411
RE: Help with Money and Decimal datatype

karthikeyan (11/20/2008)
...and send the reports to the business users...
Not quite what I was looking for... What type of report are you sending to the business users where you have 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)

November 20, 2008 at 8:07 pm

#901398

Viewing 15 posts - 47,086 through 47,100 (of 59,101 total)