Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,151 through 30,165 (of 59,101 total)

RE: Selecting from hierarchies like Managers and Employees

I forgot to look at the execution plans for the loops. They, too, grossly underestimate the number of rows even with a better index. So it has 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)

May 7, 2012 at 11:39 pm

#1484312
RE: Selecting from hierarchies like Managers and Employees

miika.langille (5/7/2012)
Would you care to elaborate on why the new version of the while loop code works so much better? Showing conclusive proof is great, but if people don't actually...
--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 7, 2012 at 10:15 pm

#1484304
RE: Referential Integrity: Who needs it - right? (Discussion)

Let's put it this way, Gail. If you're one of the folks that thinks there's something seriously wrong with allowing front end developers to "design" tables using NVARCHAR(4000) or...
--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 7, 2012 at 7:14 pm

#1484284
RE: Referential Integrity: Who needs it - right? (Discussion)

GilaMonster (5/7/2012)
Jeff Moden (5/5/2012)
I think that people who insist that the application can take care of RI are just about as flambouyantly in desregard (and equally wrong) for proper database...
--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 7, 2012 at 4:34 pm

#1484274
RE: How to Disable COM Components

kennethigiri (5/6/2012)
How do I scan DBs to see whether sp_OACreate and other such SPs are beig used?
This will scan a single DB.
SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
...
--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 6, 2012 at 8:52 pm

#1483947
RE: Responsibility for Security

I've found that the real reason why there are security holes in systems is because companies have been talked into having them. "Oh... the developers need to have DBO...
--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 6, 2012 at 8:18 pm

#1483946
RE: Selecting from hierarchies like Managers and Employees

Chuck Hoffman-291200 (5/6/2012)
Jeff, Kevin, tmarkham et. al.,
Nice job! I'm truly impressed.
I'm a long time believer in the value of peer review. Just look at what came of 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)

May 6, 2012 at 7:13 pm

#1483942
RE: Selecting from hierarchies like Managers and Employees

W. Kevin Hazzard (5/6/2012)
Agreed, Jeff, about the mindset. Simpler syntax does not equal better performance. But in this case, I believe that I'm on the right track. Look at 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)

May 6, 2012 at 6:44 pm

#1483941
RE: Selecting from hierarchies like Managers and Employees

So, we have two great questions that have been implied on this thread.
The first question is, "Will rCTE code be faster than the code in the article?" If 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)

May 6, 2012 at 6:02 pm

#1483940
RE: Selecting from hierarchies like Managers and Employees

Dave Brooking (5/6/2012)
Jeff,
Are you Tom Kyte (one of Oracle's employees) in disguise???? I used to work for a company that consumed Oracle data and so I searched for Oracle specific...
--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 6, 2012 at 1:44 pm

#1483923
RE: Selecting from hierarchies like Managers and Employees

W. Kevin Hazzard (5/6/2012)
OK Jeff, I took the challenge. I loaded 1,000,000 employees into the table with your script. Then I saved Chuck's procedures using his original names and my...
--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 6, 2012 at 1:21 pm

#1483919
RE: Selecting from hierarchies like Managers and Employees

tmarkham1 (5/6/2012)
Wasn't calling you closed mind... I said, "some people". I had 5 seconds to type a quick response, just don't have hours to devote to research. You obviously like...
--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 6, 2012 at 1:18 pm

#1483918
RE: Selecting from hierarchies like Managers and Employees

tmarkham1 (5/6/2012)
Jeff Moden (5/6/2012)You're the fourth person to say that with no proof! [font="Arial Black"]PROVE IT![/font]
Jeff:
This may come as no surprise to you, but I'm not going to take...
--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 6, 2012 at 12:49 pm

#1483915
RE: Remove successive rows with same column value

I have, indeed.
--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 6, 2012 at 10:00 am

#1483898
RE: Selecting from hierarchies like Managers and Employees

W. Kevin Hazzard (5/6/2012)
I think the recursive approach is better because it's in keeping with the set-based mindset of T-SQL.
Now that's a part of the larger problem, Kevin. People...
--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 6, 2012 at 9:44 am

#1483896

Viewing 15 posts - 30,151 through 30,165 (of 59,101 total)