Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,481 through 36,495 (of 59,102 total)

RE: Are the posted questions getting worse?

CirquedeSQLeil (10/4/2010)
CirquedeSQLeil (10/4/2010)
CirquedeSQLeil (10/4/2010)
CirquedeSQLeil (10/4/2010)
I
Am
getting
a
massive
--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 9:27 pm

#1231437
RE: Are the posted questions getting worse?

Dave Ballantyne (10/4/2010)
For those interested , attached is the script i used at sqlbits.
All pretty self explanatory really, i choose the tally split function to demonstrate
A) You cant...
--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 9:26 pm

#1231435
RE: Are the posted questions getting worse?

Jack Corbett (10/4/2010)
Roy Ernest (10/4/2010)
I will be sending an email to my members regarding the next topic they would like to see in T-SQL. That I think is the best...
--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 9:18 pm

#1231433
RE: Are the posted questions getting worse?

Stefan Krzywicki (10/4/2010)
Jeff Moden (10/4/2010)
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...
--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 9:15 pm

#1231432
RE: Are the posted questions getting worse?

Roy Ernest (10/4/2010)
I was thinking of this as an article or a blog post. It sure will make it easy for others who have no experience in setting up 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 4, 2010 at 8:04 am

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

Viewing 15 posts - 36,481 through 36,495 (of 59,102 total)