Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,141 through 34,155 (of 59,099 total)

RE: Are the posted questions getting worse?

ALZDBA (4/29/2011)
Jeff Moden (4/28/2011)
Good golly, I missed it! I missed them both, in fact. Gail has recently gone over the 23K post mark and I passed 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)

April 29, 2011 at 6:33 pm

#1318017
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Elliott Whitlow (4/29/2011)
Oh well.. I released a SQL CLR file function library on codeplex in march 2011. It is at:
http://nclsqlclrfile.codeplex.com/%5B/url%5D
Let me know what you think, what is wrong with...
--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)

April 29, 2011 at 12:16 pm

#1317905
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Sorry... posted against a 2 year old post and removed 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)

April 29, 2011 at 7:13 am

#1317791
RE: First attempt at a blog

I believe you can use certain DMV's to check on that. I just don't remember what they are.
--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)

April 28, 2011 at 10:27 pm

#1317662
RE: Paging on huge tables with row_number

Using a join to Table2 as a criteria is really the showstopper here yet it is (I assume) critical to the proper return of data. I've been testing with...
--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)

April 28, 2011 at 10:19 pm

#1317660
RE: Paging on huge tables with row_number

I know... I'm working on it. While your waiting, how many rows are in the second table and how long is your query currently taking?
--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)

April 28, 2011 at 8:26 pm

#1317646
RE: First attempt at a blog

Ah... my bad. I thought you were asking a question and I was suggesting that you attach the Execution Plans you were having trouble with.
First, thanks for posting 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)

April 28, 2011 at 6:59 pm

#1317641
RE: delete records from tables

Thanks, Manu. 🙂
--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)

April 28, 2011 at 6:48 pm

#1317639
RE: Are the posted questions getting worse?

Good golly, I missed it! I missed them both, in fact. Gail has recently gone over the 23K post mark and I passed the 25K post mark...
--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)

April 28, 2011 at 6:38 pm

#1317637
RE: Are the posted questions getting worse?

heh... I think I've done this once here before but since everyone is in such a poetic mode... sung to the tune of "Row, row, row your boat"...
[font="Arial Black"]No, no,...
--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)

April 28, 2011 at 6:31 pm

#1317635
RE: Are the posted questions getting worse?

The Dixie Flatline (4/28/2011)
Haiku
Listen... can you tell?
Someone is using cursors.
Hear the pork chops fly!
Freakin' awesome. 😀
--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)

April 28, 2011 at 6:18 pm

#1317634
RE: Paging on huge tables with row_number

Crud. My apologies. We had a bit of a crisis at work and forgot my commitment on this thread. I'll try to get to this tonight. ...
--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)

April 28, 2011 at 8:03 am

#1317275
RE: Are the posted questions getting worse?

Tom.Thomson (4/26/2011)
Anyway, I don't dare use my apabet soup here - I'm frightened of how Jeff might react.
You, good sir, have proven time and again that you deserve to 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)

April 28, 2011 at 7:54 am

#1317270
RE: SSIS ForLoop Question

hensong (4/27/2011)
Never mind, got it.....Once again Thanks for the response.
What did you end up doing, Glenn?
--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)

April 27, 2011 at 9:23 pm

#1317007
RE: Select Records For Any Month

skcadavre (4/26/2011)
First, lets build some test data...
...
I wasted too much time making up some test-data since you didn't supply any.
Nah... you did good. It's never a waste of time...
--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)

April 27, 2011 at 9:13 pm

#1317003

Viewing 15 posts - 34,141 through 34,155 (of 59,099 total)