Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,466 through 36,480 (of 59,067 total)

RE: Convert CSV values in three columns to rows

Pavel Pawlowski (9/26/2010)
But the situation differs with increased number of element. Tested it on 1333 elements (nearly 8k). The Tally table version I stopped after 19 minutes of execution time.
Do...
--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)

October 2, 2010 at 11:37 am

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

But as Oleg said for larger element count the Tally is not usable.
For the 16 element on my machine the Tally runs about 1 se. and the CLR RegEx about...
--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)

October 2, 2010 at 12:36 am

#1230660
RE: how to raise alert on table row count

Steve Jones - Editor (10/1/2010)
You could write a trigger to do this, or you could write a job that ran every minute or so and checked the table.
I'd lean towards...
--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)

October 2, 2010 at 12:20 am

#1230659
RE: Problem with CURSOR

Nevyn (10/1/2010)
Well, I've never tried it myself, so I'd probably refer to this article[/url] some guy wrote.:Whistling:
Or I'd do the running total in whatever my frontend was.
Heh... ok... now 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)

October 2, 2010 at 12:17 am

#1230658
RE: generate rows based on integer

Seriously... I'd like to know just from an educational standpoint. The only reason anyone has ever told me why they wanted to do this was to supposedly make 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)

October 2, 2010 at 12:14 am

#1230657
RE: How to remove blank spaces

gkarung (9/30/2010)
Hi All,
How to remove database unallocated space in the server.
After deleted the unwanted tables in the database we got 40gb unallocated space in the drive.
Thanks
G Arunagiri
It may seem...
--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)

October 2, 2010 at 12:10 am

#1230656
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Very cool. Thanks for the comparison, Stefan.
--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)

October 2, 2010 at 12:08 am

#1230655
RE: Are the posted questions getting worse?

Kit G (10/1/2010)
Jeff Moden (9/30/2010)
Kit G (9/30/2010)
WayneS (9/30/2010)
Steve Jones - Editor (9/30/2010)
You can pay at the door. I'll have Grant standing there intimidating people into giving up $30 or 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)

October 1, 2010 at 11:50 pm

#1230652
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/1/2010)
On a different note, I have finally broken into the Top 8 posters.
Whup! Well done, Jason!
--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)

October 1, 2010 at 11:42 pm

#1230651
RE: Are the posted questions getting worse?

Craig Farrell (10/1/2010)
While we're on the subject of sample data, anyone know where I can get 300,000+ records of description data with 400-6000 character average ( no, I didn't lose...
--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)

October 1, 2010 at 11:35 pm

#1230650
RE: Are the posted questions getting worse?

Luke L (10/1/2010)
Roy Ernest (10/1/2010)
I just wanted to let you all know that Jeff Moden gave a great presentation for our user group yesterday using Netmeeting. Everyone loved it. 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)

October 1, 2010 at 11:32 pm

#1230649
RE: Are the posted questions getting worse?

GilaMonster (10/1/2010)
jcrawf02 (10/1/2010)
Just realized the solution, I'll have to find a carrier pigeon to tie a flash drive to and send it your way.... 😉
I look forward to the delivery....
--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)

October 1, 2010 at 11:30 pm

#1230648
RE: Are the posted questions getting worse?

Steve Jones - Editor (10/1/2010)
Roy Ernest (10/1/2010)
I just wanted to let you all know that Jeff Moden gave a great presentation for our user group yesterday using Netmeeting. Everyone loved...
--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)

October 1, 2010 at 11:25 pm

#1230647
RE: Are the posted questions getting worse?

Stefan Krzywicki (10/1/2010)
Jeff Moden (9/30/2010)
Kit G (9/30/2010)
WayneS (9/30/2010)
Steve Jones - Editor (9/30/2010)
You can pay at the door. I'll have Grant standing there intimidating people into giving up $30 or 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)

October 1, 2010 at 11:17 pm

#1230646
RE: Are the posted questions getting worse?

Roy Ernest (10/1/2010)
I just wanted to let you all know that Jeff Moden gave a great presentation for our user group yesterday using Netmeeting. Everyone loved it. And they 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)

October 1, 2010 at 11:15 pm

#1230644

Viewing 15 posts - 36,466 through 36,480 (of 59,067 total)