Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,721 through 36,735 (of 59,072 total)

RE: Convert CSV values in three columns to rows

Long story short... I wouldn't use XML for splitting if I were you. 🙂
--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)

September 17, 2010 at 7:59 pm

#1223408
RE: Convert CSV values in three columns to rows

Ok... here we go...
First, here are 4 functions. I believe Oleg will recognize the one called "XML-1 (Split8KXML1 mlTVF)"....
--=====================================================================================================================
-- Create the various functions...
--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)

September 17, 2010 at 7:57 pm

#1223407
RE: Deterministic UDF slower than Non-Deterministic?

dant12 (9/16/2010)
Jeff Moden (9/15/2010)
Jeff Moden (8/3/2010)
dant12 (8/2/2010)
yeah sure ill send you a .csv if your willing to play with it, but i wouldnt bother so much. you already gave me...
--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)

September 17, 2010 at 6:14 pm

#1223399
RE: Converting a table variable into a permanent table

I'll second 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)

September 17, 2010 at 5:29 pm

#1223394
RE: Are the posted questions getting worse?

Tom.Thomson (9/17/2010)
Jeff Moden (9/17/2010)
... DBAs and DBA's are both acceptable ...
Surely not socially?
Unless perhaps it's a case of Angelic possession.
Heh... you tell me... they let Steve out 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)

September 17, 2010 at 5:18 pm

#1223389
RE: Are the posted questions getting worse?

Stefan Krzywicki (9/17/2010)
GilaMonster (9/17/2010)
Jeff Moden (9/17/2010)
GilaMonster (9/17/2010)
Steve Jones - Editor (9/17/2010)
Too slow! Removing a lot of SPAM this morning, and disabling some accounts.
Yeah, there was quite a collection 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)

September 17, 2010 at 5:16 pm

#1223388
RE: Are the posted questions getting worse?

Heh... this place is going to hell in a handbasket. I got a shirt for going over 3k. I got a shirt for going over 5k. I...
--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)

September 17, 2010 at 5:11 pm

#1223387
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/17/2010)
Has anybody else noticed how close SSC is to 1 million posts overall?
Any bets on if we could get that done by the end of the year?
Only ~12000 posts...
--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)

September 17, 2010 at 5:07 pm

#1223385
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/17/2010)
Trey Staker (9/17/2010)
CirquedeSQLeil (9/17/2010)
Just curious if anybody here has ever walked out of an interview...What would be your justifications for doing so?
I've never walked out on an interview but...
--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)

September 17, 2010 at 5:04 pm

#1223384
RE: Temp Tables and Tuning Advisor

rickK_ (9/17/2010)
Does anyone know why various #temp tables fail the analyzer and \or Display Estimated Execution Plan with an Invalid object name error. The proc works fine, 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)

September 17, 2010 at 2:11 pm

#1223313
RE: Usually never get good answers on this forum but here it goes

"Usually never get good answers on this forum but here it goes"
We're even then. We usually never get good questions on this forum, either. 😉
--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)

September 17, 2010 at 12:11 pm

#1223254
RE: How to Post Performance Problems

I'll go one step further... This article and its T-SQL Equivalent should be sticky noted to the beginning of most of the forum selections.
--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)

September 17, 2010 at 11:57 am

#1223247
RE: Are the posted questions getting worse?

Jeff Moden (9/17/2010)
GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
'postro-fees are also used to show a bit o' an accent.
Still a contraction (left out letters)
Where they should NOT be used..
In fantasy/sci-fi 'languages...
--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)

September 17, 2010 at 10:49 am

#1223188
RE: Are the posted questions getting worse?

GilaMonster (9/17/2010)
Steve Jones - Editor (9/17/2010)
Too slow! Removing a lot of SPAM this morning, and disabling some accounts.
Yeah, there was quite a collection this morning. I think I made 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)

September 17, 2010 at 10:46 am

#1223187
RE: Are the posted questions getting worse?

GilaMonster (9/16/2010)
Steve Jones - Editor (9/16/2010)
'postro-fees are also used to show a bit o' an accent.
Still a contraction (left out letters)
Where they should NOT be used..
In fantasy/sci-fi 'languages to persuade...
--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)

September 17, 2010 at 10:41 am

#1223179

Viewing 15 posts - 36,721 through 36,735 (of 59,072 total)