Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,496 through 36,510 (of 59,102 total)

RE: Converting Daily OHLCV data into weekly and monthly OHLCV

Digs (10/3/2010)
Please down load text file attached Example.xls, 'MSFT.txt', and set up table.
CREATE TABLE [dbo].[DIM_Data_OHLC](
[RecID] [int] IDENTITY(1,1) NOT NULL,
[Date] [datetime] NOT NULL,
[Open] [float] NULL,
[High] [float] NULL,
[Low] [float] NULL,
[Close] [float] NULL,
[Volume]...
--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 3, 2010 at 7:06 pm

#1230809
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/2/2010)
Brandie Tarvin (10/2/2010)
CirquedeSQLeil (10/2/2010)
Grant Fritchey (10/2/2010)
Hey guys, thanks for dumping a load of... something into my in box. What the heck were you guys smoking in here last night?
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)

October 3, 2010 at 12:40 pm

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

@Pavel,
What is the default collation on your machine, please? And thanks ahead of time for helping me figure this out.
--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 3, 2010 at 12:32 pm

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

Pavel Pawlowski (10/2/2010)
But even the Split8KTallyM is 8 times slower comparing the CLR RegEx on the hi element counts (1333).
Maybe I'm doing somethig wrong or forget something, but I'm not...
--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 3, 2010 at 12:27 pm

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

steve-893342 (10/2/2010)
Aha the 1,333 test:-) Curiously enough I had already carried out the analysis according to your CsvTest but on 10,000 Row X 1,333 Element table. Results available on request
Heh......
--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 3, 2010 at 12:22 pm

#1230784
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

Viewing 15 posts - 36,496 through 36,510 (of 59,102 total)