Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,556 through 45,570 (of 59,101 total)

RE: The Set-Based Limit

GSquared (1/26/2009)
Is that from when I told someone to stop using those on you, Jeff? Just last week, if I remember correctly.
Yes, Sir! And I have to tell...
--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 26, 2009 at 11:51 am

#932759
RE: What is RBAR? How can I avoid it?

Lynn Pettis (1/26/2009)
Cardinal Moden is an excellent resource in the fight against RBAR. I must admit to having learned quite a bit from his excellent mentoring via SSC.
Dang, 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)

January 26, 2009 at 11:47 am

#932754
RE: What is RBAR? How can I avoid it?

Sankar Reddy (1/26/2009)
Jeff, Thanks for your timely good spanking for using the TVF. I wouldn't use/propose this next time and you will see me use the numbers table here next...
--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 26, 2009 at 11:37 am

#932749
RE: Are the posted answers getting worse?

GilaMonster (1/26/2009)
Jeff Moden (1/26/2009)
The backup to such a "break" for the quirky update method is that the ORDER BY method also works although it works at about half the speed....
--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 26, 2009 at 11:35 am

#932747
RE: Newbie:Why is select doing a table scan?

GilaMonster (1/26/2009)
If that table is frequently inserted into, then I'd suggest put the cluster on the identity, even if it's never used. That way the cluster will organise 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)

January 26, 2009 at 11:29 am

#932745
RE: Slack SQL Server

As a side bar, I've finally discovered the true meaning of the acronym "CLR"...
[font="Arial Black"]C[/font]ursors, [font="Arial Black"]L[/font]oops, and other [font="Arial Black"]R[/font]BAR. 😛
--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 26, 2009 at 11:28 am

#932744
RE: Slack SQL Server

Steve Jones - Editor (1/26/2009)
majorbloodnock, well said. SQL Server does work extremely well for the basics of what we need and it's definitely one of the most stable pieces 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)

January 26, 2009 at 11:25 am

#932742
RE: SQL or Oracle

Luke L (1/25/2009)
Unfortunately, the reason why some very large companies end up dong this is that someone comes along and says he we need to represent x data y way......
--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 26, 2009 at 11:21 am

#932738
RE: Limiting users to views only in database

Grant Fritchey (1/26/2009)
Risking a pork chop, I'm going to disagree with Jeff on this.
You should look at option 1, but as was mentioned before, create a schema for the views....
--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 26, 2009 at 11:15 am

#932729
RE: The Set-Based Limit

Heh... if it's not in the "SQL Dictionary", I usually don't get it, either. I learned one just recently that very well describes some of the source of "flames"...
--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 26, 2009 at 11:02 am

#932723
RE: Are the posted answers getting worse?

GilaMonster (1/25/2009)
Jeff Moden (1/25/2009)
The ironic part about all of this is that very example actually strengthens the argument that the quirky update does always work as advertised. I'm going...
--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 26, 2009 at 10:54 am

#932719
RE: How to replace a cell value with a cell value in previous row

Sorry folks... I got busy on other stuff. I'll take a look and see if I can answer some of the questions folks directed at me, 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)

January 26, 2009 at 10:49 am

#932716
RE: Hidden RBAR: Triangular Joins

My absolute favorite standard is "MIL-TP-41".... "Make It Like The Print for once". 😛
--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 26, 2009 at 10:44 am

#932713
RE: What is RBAR? How can I avoid it?

Thanks for the feedback. And, as you can see, avoiding RBAR is quite a hot topic with most of the power users.
--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 26, 2009 at 10:10 am

#932693
RE: Are the posted questions getting worse?

GSquared (1/26/2009)
Jeff, something I have to ask:
You keep mentioning that recursive CTEs are worse than cursors. I can see that in some cases, but in cases like a hierarchy...
--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 26, 2009 at 9:49 am

#932679

Viewing 15 posts - 45,556 through 45,570 (of 59,101 total)