Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,451 through 36,465 (of 59,067 total)

RE: Are the posted questions getting worse?

Dave Ballantyne (10/4/2010)
Still cant believe that my name is sitting on the same agenda as all these MVPS , MCM's (yes plural , the universe doesnt collapse if there are...
--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 4, 2010 at 7:57 am

#1231018
RE: Are the posted questions getting worse?

Grant Fritchey (10/4/2010)
Speaking of this, I presented at a Developers code camp the other day and had an absolute blast. I've got 12-15 people in a room and none 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)

October 4, 2010 at 7:54 am

#1231014
RE: Are the posted questions getting worse?

Dave Ballantyne (10/4/2010)
All the session were filmed , so will be on the sqlbits site "at some point".
Started off , other than pre-amble, with a run through of my "Fifo"...
--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 4, 2010 at 7:45 am

#1231006
RE: Converting Daily OHLCV data into weekly and monthly OHLCV

LutzM (10/4/2010)
@jeff:
Your latest version include results for 2010-02-27 to 2010-03-05. But those are out of the date range to be queried.
I guess Digs need to decide where to place 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)

October 4, 2010 at 7:24 am

#1230986
RE: Are the posted questions getting worse?

Dave Ballantyne (10/3/2010)
Thats sqlbits all over with now , great conference. My talk seemed to go pretty well, room full of blank faces when i asked "who uses...
--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 4, 2010 at 6:20 am

#1230940
RE: Converting Daily OHLCV data into weekly and monthly OHLCV

With the understanding that you'll eventually verify what I asked, the following code does the trick. I went for logical understanding and ease of maintenance rather than code 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)

October 4, 2010 at 6:01 am

#1230931
RE: Converting Daily OHLCV data into weekly and monthly OHLCV

Digs (10/3/2010)
Jeff, a little issue with the Date used for weekly data
The daily data can be nasty.
For example I can get data for a week like these three cases:
1) Tue,...
--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 4, 2010 at 4:40 am

#1230895
RE: Converting Daily OHLCV data into weekly and monthly OHLCV

Heh... P.S.... don't worry about the correlated subqueries. The only time such a thing will become a problem is when an aggregated inequality is involved which will make for...
--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 8:42 pm

#1230815
RE: Converting Daily OHLCV data into weekly and monthly OHLCV

Digs (10/3/2010)
HI Jeff,
Max records : 40000
Average : 6000
Cool... This should do nicely with the indexes you currently have then because they're going to cause table scans the way they...
--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 8:40 pm

#1230814
RE: Converting Daily OHLCV data into weekly and monthly OHLCV

Hey Digs,
What's the max number of data rows you expect to handle at one time?
--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:21 pm

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

Viewing 15 posts - 36,451 through 36,465 (of 59,067 total)