Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,501 through 40,515 (of 59,098 total)

RE: CLR Table-Valued Function Example with Full Streaming (STVF)

RBarryYoung (12/25/2009)
Jeff Moden (12/24/2009)
...Do you think this streaming method will solve the memory issues on extremely large files? If it does, then that makes this article really worth 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)

December 25, 2009 at 9:06 am

#1096464
RE: CLR Table-Valued Function Example with Full Streaming (STVF)

Matt Miller (#4) (12/24/2009)
Sorry to say - those files are long gone for another company I no longer deal with. They were some delimited files, with varying numbers 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)

December 24, 2009 at 11:08 pm

#1096448
RE: Compare documents in folder to items in a table

TheSQLGuru (12/24/2009)
Again I inquire how I am supposed to traverse the hierarchy of the folder system with that output? Having a depth without any way to identify parent isn't...
--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)

December 24, 2009 at 10:42 pm

#1096446
RE: Need query

freeman.e.l (12/24/2009)
Dugi (12/24/2009)
I agree with you ... if you SELECT NAME FROM T-SQL_MASTERS WHERE NAME LIKE 'J%' you will retrieve the only result Jeff Moden.
Let's not forget Jamie Thomson http://sqlblog.com/blogs/jamie_thomson/
Man,...
--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)

December 24, 2009 at 6:06 pm

#1096439
RE: Need query

ss-457805 (12/24/2009)
Jeff,
This is awesome. You are a Genius.:-)
Thanks, SS. Not a genius though... just lucky as all get out. 😉 Give folks a day or two and someone...
--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)

December 24, 2009 at 5:50 pm

#1096437
RE: CLR Table-Valued Function Example with Full Streaming (STVF)

Sorry... didn't mean to turn this into a "I hate CLR's" post... I just wanted to know what this "streaming CLR" would be used for and why folks thought 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)

December 24, 2009 at 5:20 pm

#1096436
RE: CLR Table-Valued Function Example with Full Streaming (STVF)

RBarryYoung (12/24/2009)
Jeff Moden (12/23/2009)
Next question, please... What application would have the need for such a thing where it could not be done using T-SQL? Not trying to 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)

December 24, 2009 at 5:15 pm

#1096435
RE: CLR Table-Valued Function Example with Full Streaming (STVF)

Matt Miller (#4) (12/23/2009)
I had attempted to use something like this to bring in data from an external file. One of those "ugly delimited" files, kind of delimited and...
--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)

December 24, 2009 at 5:06 pm

#1096434
RE: CLR Table-Valued Function Example with Full Streaming (STVF)

timothyawiseman (12/24/2009)
Jeff Moden (12/23/2009)
I'm not picking on the author here... it's a general statement that I bring up to anyone who may be considering the use of CLRS... Don't...
--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)

December 24, 2009 at 5:01 pm

#1096433
RE: Incrementing Values

Dugi (12/24/2009)
Jeff Moden (12/24/2009)
Dugi, thanks for the kudo but it's not mine alone... take a look at the "credits" on that thing... lots of folks had some great ideas 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)

December 24, 2009 at 4:56 pm

#1096432
RE: Table variable as Output Parameter

Jeff Moden (1/2/2009)
aziz.kapadia (12/31/2008)
Can I declare table variable as output parameter in stored procedure?
Probably of more importance, what is it that you're trying to do? You'll be amazed at...
--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)

December 24, 2009 at 4:34 pm

#1096428
RE: Usage of "Tally Table"

Never mind...
--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)

December 24, 2009 at 4:30 pm

#1096427
RE: Tally Table - Splitted values

Nah... nothing so superior or diligent... I had the need to visit my Tally table article and it popped up on the right as a related "FORUM" entry.
Some of these...
--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)

December 24, 2009 at 4:03 pm

#1096424
RE: Tally Table - Splitted values

Karthik,
I know this is an old post but just a couple of tips here... I noticed you have the following...
If @ID =''
Begin
Select @ID = Null
End
If @sp-2=''
Begin
Select @sp-2 = Null
End
If @ClassId...
--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)

December 24, 2009 at 3:39 pm

#1096421
RE: Tally Table - Splitted values

SwePeso (5/29/2008)
Did you try my latest suggestion then?
Heh... considering the date of that post and today's date, I'm thinking that requires some little thought, eh? 😛
--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)

December 24, 2009 at 3:35 pm

#1096419

Viewing 15 posts - 40,501 through 40,515 (of 59,098 total)