Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,751 through 54,765 (of 59,089 total)

RE: Limit Resources to UGLY query

Heh... and if they change the way Order By works, we'd all be screwed, too!...
...Wait, they did 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)

October 4, 2007 at 5:18 pm

#739379
RE: Performance required on > 4 million records

dhay1999 (10/4/2007)
Jeff,
If you are still around I'd like to see a skeleton of what you accomplished. I'm trying to do the same thing with over 150 million rows. ...
--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 4, 2007 at 9:00 am

#739141
RE: Limit Resources to UGLY query

noeld (10/3/2007)
Ok that's the statement. Where does it says that it will update the varibles following a certain order ?
We know that, so far, we have been able to force...
--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 3, 2007 at 11:23 pm

#738935
RE: Limit Resources to UGLY query

Nothing undocumented... you need to look in BOL for the UPDATE... I've bolded the part of the update I used....
UPDATE
{
...
--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 3, 2007 at 11:10 pm

#738933
RE: Remove Decimals Without Rounding

Tomm Carr (10/3/2007)
Sorry, Jeff. You got the third method to operate a little faster by removing the setup just before entering the loop. This is a crucial step. Without 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 3, 2007 at 11:06 pm

#738932
RE: Increment non identity column in INSERT query

Peter,
Although the double correlated subquery will work, I'm also pretty sure it will kill batch performance because of the triangular join in it...
http://www.sqlservercentral.com/Forums/Topic359124-338-1.aspx#bm360151
--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 3, 2007 at 7:31 am

#738605
RE: Altering a table with in a stored procedure

Vishal,
Just a thought... Is this a permanent nonreporting you're modifiying? The reason I ask is if you're actually doing this to some "real" data (other than a reporting 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)

October 3, 2007 at 7:22 am

#738596
RE: Limit Resources to UGLY query

I still don't know what "undocumented behaviour" Noel is talking 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)

October 3, 2007 at 7:11 am

#738585
RE: Querying the max row length

Mahesh Gupta (10/2/2007)
What exactly do you mean by Max Length of the row ?
The maximum length of a row can be 8060 bytes. In this case, some of 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)

October 3, 2007 at 6:58 am

#738576
RE: Querying the max row length

Ninja's_RGR'us (10/2/2007)
When was that?? I never saw it work like I want it to ;)... like the old one.
Actually, all that stuff worked... for about the first two days...
--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 3, 2007 at 6:56 am

#738572
RE: can we modify system tables in SQL Server 2000?

Heh... already are... hardcore DBA just wouldn't allow this.
--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 3, 2007 at 6:50 am

#738570
RE: Querying the max row length

Lowell (10/2/2007)
the thing about color is that you MUST enter the double quotes to get it to work.
input = #0000FF is BAD
input = "#0000FF" is GOOD
Heh... thanks Lowell... but 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 2, 2007 at 10:48 pm

#738494
RE: Remove Decimals Without Rounding

Yeah, huh? Using loops comes highly unnatural to me. 😀 Goes against my data-troll grain.
The other place I saw it was with a splitter function that used 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)

October 2, 2007 at 10:44 pm

#738493
RE: Sproc calling Sproc

Bill,
I guess I don't understand why you are calling these procs as passthrough queries from Access... can't you schedule this as a job or run it through OSQL? 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)

October 2, 2007 at 10:35 pm

#738490
RE: Remove Decimals Without Rounding

You can touch it. It won't hurt you.
Heh... and folks think Serqiy is a smartass??? :laugh:
Anyway, point well taken and I guess I have to eat a little crow 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)

October 2, 2007 at 10:27 pm

#738486

Viewing 15 posts - 54,751 through 54,765 (of 59,089 total)