Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,921 through 34,935 (of 59,099 total)

RE: In what circumstances are there no other option than to use cursors?

Heh... on something that large, I just drop the partition that has gone past the age limit. If I don't have the Enterprise edition, then I drop the "sub-table"...
--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)

February 25, 2011 at 7:39 pm

#1291871
RE: Odd Questions

boulang (2/25/2011)
You're locked in a cell with a steel floor. At the center of the room is a pipe with massively thick walls securely welded to the floor all...
--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)

February 25, 2011 at 7:29 pm

#1291868
RE: Grouping and crosstab like behaviour.... hairy query

Sorry... I almost forgot. Here are the results I get from the final SELECT in the solution...
FactorPartFromPartTo
0.229383000011400-95855-00011400-95857-000
0.334486000024356-89000-00024356-89002-000
0.212938000035100-07g00-01935100-07g02-019
0.334486000051400-00001-00051400-00003-000
0.229383000061000-00001-00061000-00003-000
0.212938000065310-07G01-00065310-07G03-000
0.300000000065310-07G04-00065310-07G06-000
0.212938000065310-07G07-00065310-07G09-000
--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)

February 25, 2011 at 7:12 pm

#1291865
RE: Grouping and crosstab like behaviour.... hairy query

ZA_Crafty (2/25/2011)
mister.magoo (2/25/2011)
ZA_Crafty (2/24/2011)
mister.magoo (2/24/2011)
Try this:
select Factor,min(PartNumber) as PartFrom,max(PartNumber) as PartTo
from Factors2Process
group BY Factor,stuff(PartNumber,7,5,'')
order by Factor,PartFrom
And by the way - there is no order by on the query in...
--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)

February 25, 2011 at 7:05 pm

#1291864
RE: How To Work with Files based on file name patterns

YSLGuru (2/22/2011)
Jeff Moden (2/14/2011)
YSLGuru (2/14/2011)
GOTCHA #1: The process we use to download an d import is proprietary and can not be altered so we can't simply not download the few...
--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)

February 25, 2011 at 5:39 pm

#1291849
RE: date for 15th Feb 12.00 a.m

You bet. Thanks for the feedback.:-)
--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)

February 25, 2011 at 5:09 pm

#1291846
RE: Finding duplicate values in very large table. Select Row_number() over too slow

Indianrock (2/23/2011)
It will be up to the developers to decide if they're going to revise anything. Unless Systems decides to "insist" I've done 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)

February 25, 2011 at 5:08 pm

#1291845
RE: Are the posted questions getting worse?

WayneS (2/25/2011)
Jeff Moden (2/17/2011)
The Dixie Flatline (2/17/2011)
Jeff Moden (2/16/2011)
WayneS (2/15/2011)
Can anyone point me to a delimited split function that works on a varchar(max)? I know that Jeff's DelimitedSplit8K works on...
--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)

February 25, 2011 at 4:49 pm

#1291839
RE: Are the posted questions getting worse?

Stefan Krzywicki (2/24/2011)
Yeah, most beer ads annoy the hell out of me, not only are they primarily selling sex, everyone in them is stupid and an alcoholic.
ah kin pruv ah...
--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)

February 25, 2011 at 4:46 pm

#1291838
RE: Are the posted questions getting worse?

Brandie Tarvin (2/24/2011)
Tom.Thomson (2/23/2011)
I don't see much point in attempting obfuscation if the enemy can see inside the database.
That's a good point, Tom. But is "enemy" a good word choice...
--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)

February 25, 2011 at 4:33 pm

#1291836
RE: Are the posted questions getting worse?

HowardW (2/24/2011)
What are people's thoughts on whether an update operation on a 10 million row table (a selective update, but probably around 1-2 million rows affected) holding 400,000+ Page locks?...
--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)

February 25, 2011 at 4:27 pm

#1291835
RE: Are the posted questions getting worse?

jcrawf02 (2/23/2011)
Brandie Tarvin (2/23/2011)
LutzM (2/22/2011)
Jeff Moden (2/21/2011)
...
I dun no... DE-troit boy goin ta ohia mur dan wonce in da sames yer mite git da kin folk resluss en...
--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)

February 25, 2011 at 4:23 pm

#1291833
RE: Are the posted questions getting worse?

Jack Corbett (2/22/2011)
Steve Jones - SSC Editor (2/22/2011)
On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles 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)

February 25, 2011 at 4:13 pm

#1291831
RE: Are the posted questions getting worse?

SQLkiwi (2/22/2011)
Steve Jones - SSC Editor (2/22/2011)
On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles of encrypting?...
--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)

February 25, 2011 at 4:10 pm

#1291830
RE: Are the posted questions getting worse?

Tom.Thomson (2/22/2011)
GilaMonster (2/21/2011)
GSquared (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
jcrawf02 (2/21/2011)
Jeff Moden (2/21/2011)
WayneS (2/20/2011)
For those going to SQL Saturday #69 in Philly, I'll be presenting @ 2:15. I'm getting pretty excited about this!
Click...
--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)

February 25, 2011 at 4:03 pm

#1291825

Viewing 15 posts - 34,921 through 34,935 (of 59,099 total)