Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,846 through 43,860 (of 59,097 total)

RE: SET vs SELECT

Florian Reischl (5/9/2009)
Jeff Moden (5/9/2009)
BTW - It is good to see growing acceptance of the idea that ANSI standards are kinda 'blah'. I couldn't agree more 🙂
Man, I agree...
--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 9, 2009 at 8:52 am

#991625
RE: SET vs SELECT

John Esraelo (5/9/2009)
have not we have had kicked this dead horse plenty..
I think we did..
:))
The bones of these types of dead animals are interesting... its especially interesting to see how...
--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 9, 2009 at 7:57 am

#991621
RE: SET vs SELECT

Paul White (5/9/2009)
Jeff Moden (5/8/2009)
Paul White (5/8/2009)
When assigning multiple variables from constants, SELECT is significantly quicker than separate SET statements.
Heh... I agree, but where's the code to prove 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)

May 9, 2009 at 7:53 am

#991620
RE: SET vs SELECT

Paul White (5/8/2009)
John,
When assigning multiple variables from constants, SELECT is significantly quicker than separate SET statements.
Just adding that for completeness.
Paul
Heh... I agree, but where's the code to prove 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)

May 8, 2009 at 8:00 pm

#991547
RE: SET vs SELECT

RBarryYoung (5/8/2009)
*sigh* I'm so misunderstood. 🙁
Heh... it's the helmet, Barry... can't see your eyes. 😛
--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 8, 2009 at 7:58 pm

#991545
RE: SET vs SELECT

John Esraelo (5/8/2009)
1> code portability, because of the systems and software shelf-life and change in technology
I don't believe in the myth of code portability. Consider first that even 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 8, 2009 at 7:56 pm

#991544
RE: Matrix multiplication without cursors?

Yep... the TOP 100 PERCENT thing works just fine although a whole lot of people will tell you
that order shouldn't matter in most processing. Except for things 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 8, 2009 at 7:37 pm

#991543
RE: Just testing the new code window... please disregard

Yah... you're right... 1 in a row. 😛
--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 8, 2009 at 4:52 pm

#991517
RE: Matrix multiplication without cursors?

PhilM99 (5/8/2009)
Here are the data as attached files...
Those files look pretty good. Instead of me trying to weed through this whole post, care to "nut shell" the problem you're...
--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 8, 2009 at 3:24 pm

#991492
RE: Just testing the new code window... please disregard

Just another test... (nothing has changed... all faults still present especially when copy from the forum to QA or SSMS).
drop table tally
GO
--===== Create and populate the Tally table on 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 8, 2009 at 3:08 pm

#991486
RE: Matrix multiplication without cursors?

SELECT TOP 100 PERCENT * FROM --was 3000
--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 8, 2009 at 3:03 pm

#991481
RE: UPDATE column with auto number depending on field value ?!

m.berggren (5/6/2009)
Finally i got i to work!
Was searching the internet back and forward regarding this clustered index issue, found a lot of information and tried a lot without any luck....
--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, 2009 at 10:27 pm

#990833
RE: DBCC DBReindex with "Sort In TembDB"

Thanks Jeff and Michael,
What I've found is that even if you use 2k5 tools, BOL states that DBCC REINDEX will be used and that the "Sort in TempDB" option will...
--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, 2009 at 10:23 pm

#990829
RE: Do You Need an IT or CS Degree to be a Successful DBA?

BobMcC (5/7/2009)
I've been a computer guy all my adult life, before home computers were even considered. I was one of those people who had a Radio Shack TRS-80.
Heh... rookie. 😉
--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, 2009 at 10:20 pm

#990828
RE: Enhancing the readability of your code: Table aliasing in sql

42
--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, 2009 at 10:17 pm

#990825

Viewing 15 posts - 43,846 through 43,860 (of 59,097 total)