Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,036 through 34,050 (of 59,099 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

This thread has indeed been a pleasure. Not only did I get a great response to the article, but we've collectively gotten a great enhancement to the original code...
--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 7, 2011 at 10:54 am

#1321389
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

rmechaber (5/6/2011)
Wow, what a difference 2 years makes:
Jeff Moden, February 2009, http://www.sqlservercentral.com/Forums/FindPost652105.aspx:
With the exception of RegEx, damned near all CLR's are simply not the right way to do it.
Jeff...
--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 6, 2011 at 9:45 pm

#1321357
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Agh! Sorry for my absence, folks. Thank all of you for covering for me. I haven't tested them for myself, yet, but Peter's modifications make a whole...
--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 6, 2011 at 9:21 pm

#1321355
RE: JUST FED UP with SSIS. Simple copy of 800 tables to another database...

bimplebean (5/5/2011)
I just created a database with views that point to tables in production!
If, by chance, users are allowed to write their own reports against such things, you may 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)

May 5, 2011 at 1:59 pm

#1320667
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

gary.rumble (5/5/2011)
My sincere apologies for wasting your time.
I appreciate your humility, but things like that just can't be classified as a waste of time, Gary. What if your code...
--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 5, 2011 at 12:53 pm

#1320637
RE: assistance with SQL (COUNT, GROUP BY, HAVING, etc...)

I don't know much about how you pass things (ie: variables, etc) to reports in SSRS but it seems to me that you'd only need to include a variable in...
--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 5, 2011 at 7:33 am

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

Sorry... I didn't forget you... I just got busy. I'll be back.
--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 5, 2011 at 6:45 am

#1320331
RE: assistance with SQL (COUNT, GROUP BY, HAVING, etc...)

mmontero (5/4/2011)
Possible in 1 SQL statement?
The answer to that question is almost always "Yes". Now, please tell us why you think you need it to be a single query,...
--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 5, 2011 at 12:34 am

#1320222
RE: Query taking long time for completion. -- URGENT!!

jai_422 (5/4/2011)
Hi All,
We are using SQL Server 2005 Enterprise edition with SP4 installed on it. Actually its our reporting server.
Every month we...
--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 5, 2011 at 12:32 am

#1320221
RE: JUST FED UP with SSIS. Simple copy of 800 tables to another database...

I may have missed it in the posts above... forgive me if I did.
If you have a SAN, it frequently comes with (or is an optional purchase that's well worth...
--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 5, 2011 at 12:29 am

#1320220
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Agh... I ran into a glitch with Peter's code and I sent it back to him. No more tests 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)

May 4, 2011 at 11:37 pm

#1320209
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

WayneS (5/4/2011)
Jeff Moden (5/4/2011)
Oh... and the dust bunnies said they made a new batch and it's in the freezer as we speak. Gotta love courteous dust bunnies. 😀
They said...
--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 4, 2011 at 11:35 pm

#1320207
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

WayneS (5/4/2011)
How did Peso's splitter compare? He usually has some wickedly fast routines...
Dang it! I knew I was forgetting something! I'll be back.
Oh... and the dust...
--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 4, 2011 at 10:05 pm

#1320193
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Code for the tests that produced the data for the above charts is attached to this post.
--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 4, 2011 at 10:02 pm

#1320192
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Here are the runs using random elements for 1 to 10 characters in size with the first chart showing just 1 to 50 elements per row and the second chart...
--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 4, 2011 at 9:35 pm

#1320185

Viewing 15 posts - 34,036 through 34,050 (of 59,099 total)