Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,891 through 49,905 (of 59,091 total)

RE: SYNTAX ERROR - please assist...

When you double click on the error, it takes you to the line causing the problem... now, lemme ask... do you see anything at all wrong with the following?
BETWEEN 639...
--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)

June 19, 2008 at 12:38 pm

#831320
RE: Fast way to create temp table from existing table definition

Heh... well said, Ted. That's why one of my favorite lines is "Really? Do you have an MS URL or some test code that proves 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)

June 19, 2008 at 12:23 pm

#831305
RE: From Developer to DBA - Wise career move?

Heh... I end up doing that all the time... someone responds to a really old thread and I just don't go back to the beginning to look when it started....
--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)

June 19, 2008 at 11:23 am

#831271
RE: Query Performance Difference with Temp Table Scope

Send it to Steve Jones... he's an MVP... if he doesn't have contacts, no one has contacts... 😀
--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)

June 19, 2008 at 11:15 am

#831264
RE: Fast way to create temp table from existing table definition

Heh... yeah... I knew that... I was just clarifyin' 😀 Wanted to amplify what you were saying because it's such a myth now.
It's amazing to me 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)

June 19, 2008 at 11:03 am

#831257
RE: Fast way to create temp table from existing table definition

Heh... I think I just gave myself an idea for an article 😉 This same fear/question get's asked a lot...
--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)

June 19, 2008 at 10:45 am

#831239
RE: Fast way to create temp table from existing table definition

Matt Miller (6/19/2008)
Actually - the other person was me, and the comment centered around the "locking TempDB" urban legend that seems to pop up a lot. That got 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)

June 19, 2008 at 10:42 am

#831236
RE: Suggested Approaches Appreciated

Seggerman (6/19/2008)
Not that it matters but carrot is what, in a bunch, BunnyRabbit on Captain Kangaroo used to put up on the counter all the time
I believe the ^ (capital...
--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)

June 19, 2008 at 7:29 am

#831089
RE: Virtual PM's for Jeff...

Matt Miller (6/18/2008)
Heck I often think I get more out of doing the actual testing than those watching on the sides, so it's certainly not entirely altruistic
Thanks for looking for...
--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)

June 18, 2008 at 11:44 pm

#830890
RE: Virtual PM's for Jeff...

Ya gotta send me a copy of what you did... I'd love to see your implementation... 🙂
--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)

June 18, 2008 at 11:36 pm

#830888
RE: Virtual PM's for Jeff...

Ack! I see what you mean...
--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)

June 18, 2008 at 10:22 pm

#830877
RE: Non-Sequential Insertion of Data from Temp Table or Arraylist Structure From Within Nested Loop - Inserting Values into Related Tables with Identity Key, CLR or CTE Needed

I'd like to see the URL for the "regulation" that started all 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)

June 18, 2008 at 7:54 pm

#830861
RE: Eliminating Cursors

Are we all missing a good solution to the cursor problem, here?
Nope... with the correct indexing, the CLR looses in speed and maintainability. And this is a pretty rare...
--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)

June 18, 2008 at 6:44 pm

#830853
RE: Limitation fo AND's and OR's

It's just a test to see what the max number of OR's can be...
--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)

June 18, 2008 at 6:30 pm

#830852
RE: Query Performance Difference with Temp Table Scope

Grant Fritchey (6/18/2008)
Ummmm. That was strange. Where the heck did the execution plan go?
Cool... it's not just my machine and it's not just me... gettin' old enough where I have...
--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)

June 18, 2008 at 6:17 pm

#830849

Viewing 15 posts - 49,891 through 49,905 (of 59,091 total)