Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,851 through 50,865 (of 59,098 total)

RE: Stored Procedure - which is faster/better?

You don't actually need a numbered column using the TOP (XX) methods... just need a good set of indexes and the correct "sort".
--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)

May 1, 2008 at 6:25 am

#809492
RE: cursor through user databases the SEQUEL

Ok... thanks... just trying to figure it all out... I think that's the last piece. I'll see what I can do tonight.
--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)

May 1, 2008 at 6:18 am

#809491
RE: DatePart Function

Grant Fritchey (5/1/2008)
Oops. Modulo 3.
:blush:
Heh... I've done the exact same thing... start thinking "Quarters", start writing "4'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)

May 1, 2008 at 6:15 am

#809489
RE: DatePart Function

rbarryyoung (4/30/2008)
Jeff Moden (4/30/2008)
I'm curious... Why 4 months? That's a third of a year...
That's probabrly why, Jeff. I did some work for an insurance company several years ago...
--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)

May 1, 2008 at 6:14 am

#809488
RE: DatePart Function

I'm curious... Why 4 months? That's a third of a year...
--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)

April 30, 2008 at 10:53 pm

#809441
RE: Stored Procedure - which is faster/better?

I found it... it's not as robust as I thought it was, but it does have several pieces of test code along with some reasons why some works better than...
--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)

April 30, 2008 at 10:37 pm

#809439
RE: Boost TSQL query code

Nice job, Lynn!
--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)

April 30, 2008 at 10:22 pm

#809437
RE: Managing column_id when using COLUMNS-UPDATED

Like Michael said... can't be done unless you drop/recreate the table.
--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)

April 30, 2008 at 9:17 pm

#809423
RE: Query Slow on the first run

Updating statistics can't be done in parallel... gotta be done after all the data is loaded.
--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)

April 30, 2008 at 9:13 pm

#809422
RE: Stored Procedure - which is faster/better?

If you were in charge of a project, would you tolerate a 5-6 second lag time even on millions of rows? Rhetorical question, for sure because I know 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)

April 30, 2008 at 8:56 pm

#809420
RE: Create a Tally or Numbers Table

Simple... Just like I said in the too short write up... I prefer the word "Tally" to "Number" 😀
--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)

April 30, 2008 at 8:52 pm

#809419
RE: Boost TSQL query code

luissantos (4/30/2008)
an also, i' am not understand very well the result of :
ml.data >= dateadd(yyyy,datediff(yyyy,0,'20080101'),0) and ml.data< dateadd(yyyy,datediff(yyyy,0,'20080131') + 1,0)
Lynn... I'm thinking that one is all yours 😀
--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)

April 30, 2008 at 8:09 pm

#809410
RE: its definately a SQL Server Bug (table with 80 million rows)

Yeah you can... insert a million rows at a time instead of all 80 million. Log won't grow but a bit on simple recovery.
--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)

April 30, 2008 at 7:59 pm

#809409
RE: Another Crappy Cursor

If you really want some speed out of this, consider the following article (Grouped Running Total and Running Total sections), please... should be able to do 223,000 rows in about...
--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)

April 30, 2008 at 7:50 pm

#809408
RE: Stored Procedure - which is faster/better?

rbarryyoung (4/30/2008)
There is not that much difference between them, performance-wise.
The first one is clearly older as it uses the deprecated SET ROWCOUNT XX (this should be changed to TOP XX...
--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)

April 30, 2008 at 7:46 pm

#809406

Viewing 15 posts - 50,851 through 50,865 (of 59,098 total)