Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,291 through 40,305 (of 59,072 total)

RE: parse comma-delimited list into seperate columns

@Wayne, Lutz, and Jason,
When some of the Ninjas on this site did some extreme "split" testing, one of the things that we found out was that if all the rows...
--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)

January 11, 2010 at 8:47 pm

#1102156
RE: parse comma-delimited list into seperate columns

WayneS (1/11/2010)
Well, the concept comes from Jeff. 'nuf said. 😉
:blush:
Still, that's an interesting warp on the "quirky update". Nicely done, Wayne.
It would be interesting to run a race between...
--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)

January 11, 2010 at 8:41 pm

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

RBarryYoung (1/8/2010)
Great article again, Jeff! You just can't beat the classics. 😀
Thanks, Barry. Always good to hear from you and I hope your back is treating 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)

January 9, 2010 at 9:48 am

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

Bill Parrott (1/8/2010)
Very good article! I can't tell you how much time I've spent having to parse delimited in T-SQL. While I haven't gotten all the way through...
--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)

January 9, 2010 at 9:45 am

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

mohd.nizamuddin (1/8/2010)
Excellent article.
BTW I have another version of CTE, which splits delimited string without tally table. I think it works efficiently, also. Please have a look...:-)
Thanks for the feedback, Mohd.
Several...
--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)

January 9, 2010 at 9:40 am

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

jamesburkill-1146441 (1/8/2010)
In SQL Server 2008 you most certainly CAN parse a table variable as a parameter. When used in conjunction with visual studio 2008 you can even parse 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)

January 9, 2010 at 9:35 am

#1101395
RE: Are the posted questions getting worse?

GilaMonster (1/9/2010)
Great, now I'm getting Twitter messages (along with the PMs and mails) "Please answer this forum thread"
Heh... that's why I've not gone there. I get a lot 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)

January 9, 2010 at 8:29 am

#1101379
RE: Hitting nVarchar(max) limitation when running exec sp_executesql

Thanks for the tip, Peter. That's one thing I never really paid attention 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)

January 9, 2010 at 7:47 am

#1101373
RE: Rebuild Index Task fails

Ali_SQLDBA (1/9/2010)
42.04962GB --LDF
46Gb --Total
4.41632GB-- MDF
Actually, we dont take any log backups. All we do is daily full backups. Also, the recovery model is Full. I know everything is smelling weird....
--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)

January 9, 2010 at 7:43 am

#1101372
RE: Rebuild Index Task fails

Ali_SQLDBA (1/9/2010)
Please advice Immediately.
Thanks
Ali
As a bit of a friendly tip, Ali... I know it's just a difference in languages but the words you used combined with the extreme brevity...
--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)

January 9, 2010 at 7:36 am

#1101371
RE: Running total , missing date , NULL in amount, exception handling

I can't be sure because I was actually there to see everything happen, but it probably has to do with the number of reads before and after tuning. Queries...
--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)

January 9, 2010 at 7:29 am

#1101369
RE: Hitting nVarchar(max) limitation when running exec sp_executesql

Peter Brinkhaus (1/8/2010)
I just downloaded the latest version of BOL 2005 (november 2008). The text didn't change. The topic 'sp_executesql (Transact-SQL)' is annotated as follows: Updated: 5 December 2005. So...
--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)

January 8, 2010 at 11:17 pm

#1101309
RE: Hitting nVarchar(max) limitation when running exec sp_executesql

Heh... wouldn't be the first time MS documentation is, ummm... "misleading". Guess I need to do some digging and find out if VARCHAR(MAX) is implicitly convertable before I bad...
--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)

January 8, 2010 at 10:23 am

#1101046
RE: Execution of DISTINCT Clause

mohd.nizamuddin (1/7/2010)
Thanks for your responses.
But my problem is not the getting data (output) efficiently, rather I want to know that when I was using DISTINCT clause along with COALESCE, 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)

January 8, 2010 at 9:47 am

#1101008
RE: Jr sql dba phone interview questions

ddlawal (1/8/2010)
Been in IT for awhile. Never felt so fullfilled since I took on dba role.
Being a hard worker, I love the challenge and the constant trying to better...
--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)

January 8, 2010 at 9:42 am

#1100999

Viewing 15 posts - 40,291 through 40,305 (of 59,072 total)