Jeff Moden

Forum Replies Created

Viewing 15 posts - 33,496 through 33,510 (of 59,099 total)

RE: Workload splitting?

David Lester (6/22/2011)
What are some of the more common ways/splits used to handle these sorts of issues? My hunch/instinct would be spliting the functions out to different boxes by similar...
--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)

June 25, 2011 at 9:26 am

#1344085
RE: Quick question on zip code searches: U.S. and Canada

matt6749 (6/25/2011)
Jeff - Thank you SO much for your help. Your brain power is really impressive. Now I'm reminded why I can't get programming jobs very easily! ...
--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)

June 25, 2011 at 9:13 am

#1344084
RE: Bug in CTEs?

Ken McKelvey (6/24/2011)
I am trying to write an inline splitter function based on Jeff Moden’s recent article,...
It seems that things have gotten a bit complex on this problem and 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)

June 25, 2011 at 8:46 am

#1344081
RE: Are the posted questions getting worse?

I know the answer is "because they're twits", but why are twits always compelled to finish with a nasty remark?
http://www.sqlservercentral.com/Forums/FindPost1131551.aspx
--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)

June 25, 2011 at 12:48 am

#1344034
RE: Author Guidelines

ark.trofman (6/24/2011)
So, please, could you learn English first, and then look from your unreachable heights down at the people who try to publish here ?
You were doing fine right up...
--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)

June 25, 2011 at 12:19 am

#1344032
RE: Quick question on zip code searches: U.S. and Canada

Oh yeah... I almost forgot. Part of the problem with the original code and the reason why it could only do a Clustered Index Scan was because of 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)

June 24, 2011 at 10:30 pm

#1344023
RE: Quick question on zip code searches: U.S. and Canada

p.s. That code uses 2 Index Seeks. One for the first single row lookup and the other to find the 1,333 ZipCodes in the Latitude Optimization for 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)

June 24, 2011 at 9:54 pm

#1344019
RE: Quick question on zip code searches: U.S. and Canada

Ok... here's the way I'd do this job so that I can get the best speed possible out of it.
First, you have to dump that scalar function for Distance 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)

June 24, 2011 at 9:50 pm

#1344018
RE: Quick question on zip code searches: U.S. and Canada

Just so you know, I'm working on this and I've solved the problem of the Clustered Index Scan. I've just got some more to do on it.
--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)

June 24, 2011 at 6:56 pm

#1344012
RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

opc.three (6/24/2011)
Be careful with table variables. They always optimize with an assumed rowcount of 1 so can produce very bad execution plans...even with small actual rowcounts.
A statement level OPTION(RECOMPILE) will...
--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)

June 24, 2011 at 3:17 pm

#1343949
RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

Craig Farrell (6/24/2011)
Jeff Moden (6/24/2011)
Craig Farrell (6/23/2011)
This conversation resparked a curiousity on my part.
When I run that code as a single unit, it keeps returning the following error...
There is already...
--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)

June 24, 2011 at 3:14 pm

#1343945
RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

I wasn't going to post until I got home from work to give some demo's (I don't have time while at work) but one of the things to consider (that...
--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)

June 24, 2011 at 10:28 am

#1343797
RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

THE-FHA (6/24/2011)
SQL 2008 come with query execution plan and estimation. try testing this queries and see the estimated results.
Nah... the execution plan frequently lies for things having to do with...
--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)

June 24, 2011 at 10:25 am

#1343794
RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

opc.three (6/24/2011)
Jeff Moden (6/24/2011)
Craig Farrell (6/23/2011)
This conversation resparked a curiousity on my part.
When I run that code as a single unit, it keeps returning the following error...
There is already an...
--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)

June 24, 2011 at 10:23 am

#1343791
RE: Which one is better select * into # temp from tableA Vs create #temp table insert into...

THE-FHA (6/24/2011)
Ever thought of the Query Analyzer?
the first option is best.
What on Earth are you talking about? First Query Analyzer is for 2000 and second, I meant running running...
--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)

June 24, 2011 at 10:22 am

#1343790

Viewing 15 posts - 33,496 through 33,510 (of 59,099 total)