Jeff Moden

Forum Replies Created

Viewing 15 posts - 50,341 through 50,355 (of 59,099 total)

RE: Should I use sp_rename?

Rob Reid (5/23/2008)
Whats a passthrough view? Like a materialised view created on a timed job maybe?
I haven't done much work with views and I definitley don't need the data 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 23, 2008 at 4:49 pm

#819938
RE: How to update table without primary key

Why not, indeed... that would be the way to go...
--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 23, 2008 at 3:29 pm

#819927
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

That's some of the best compliments I could hope for, Tom... someone adding this type of code to their library. Thanks!
If you haven't done so already, here's a recent...
--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 23, 2008 at 3:22 pm

#819925
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

ALZDBA (5/23/2008)
Jeff Moden (5/23/2008)
... or when parallism takes over. Even then, an Order By and a OPTION (MAXDOP1) will take care of that....
:ermm:
Just a little reminder of a nice...
--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 23, 2008 at 9:25 am

#819769
RE: DELETE DUPLICATE RECORDS

tosscrosby (5/23/2008)
Jeff Moden (4/29/2008)
SQL ORACLE (4/29/2008)
You cannot delete duplicates directly from a table unless you would like to delete rows, which are duplicated.
Any bets? 😉
Jeff, I am not doubting your...
--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 23, 2008 at 9:00 am

#819749
RE: exec sp_executesql

And, I take it, line 153 is somewhere in the code you posted?
--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 23, 2008 at 8:55 am

#819742
RE: Date String

Heh... nope... none of that... I don't even join it with a Tally Table to preserve the dates or anything... it just bubbled to the top on a simple text...
--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 23, 2008 at 8:54 am

#819741
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Anirban Paul (5/23/2008)
Awesome one Jeff. Another bomb. I just wonder how much pain you take to write these articles? Excellent one. Keep it up......:)
Thanks for the great feedback and 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 23, 2008 at 8:48 am

#819733
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

jcrawf02 (5/23/2008)
Yeah, I know, but I have limited access to the system, and can't access the system tables at all, or create indexes. Stuck with the while loop 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)

May 23, 2008 at 8:09 am

#819695
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

In case you take Hugo's post to heart...
Yep... I agree... it ain't ANSI. Oracle (and several other RDBMS's) don't have this ability. Lot's of stuff in this world...
--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 23, 2008 at 7:53 am

#819681
RE: Date String

Sorry... didn't mean to get you excited. 🙂
"Flag" a post, in this case, meant that I save the URL for the post in my "Things to follow up on" list...
--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 22, 2008 at 10:48 pm

#819482
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

Good stuff, Gus! Looks like I have a couple of more things to play with. Glad you were bored this morning! 🙂
--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 22, 2008 at 7:18 pm

#819460
RE: Date String

Heh... no problem... I didn't remember either... was reviewing old posts that I had flagged 'cause I knew I'd forget.
Thanks for the feedback!
--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 22, 2008 at 6:45 pm

#819459
RE: Should I use sp_rename?

In that case, I think I'd be tempted to use a passthrough view instead of a synonym.
--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 22, 2008 at 6:40 pm

#819456
RE: Getting tables in a like

Cool... if you get the chance, can you post your solution? I'm sure lot's of folks would like to see 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)

May 22, 2008 at 6:39 pm

#819455

Viewing 15 posts - 50,341 through 50,355 (of 59,099 total)