Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,796 through 36,810 (of 59,099 total)

RE: XML "CSV" Splitter

I can't even get things to slow down by changing to some "unusual" collations when building the data table. Again, I don't know why Brad is getting such 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)

September 15, 2010 at 11:23 pm

#1221895
RE: XML "CSV" Splitter

I left some notes on Brad's forum that Dave provided a link to. I can't (yet) figure out what he may have done differently than me because I'm sure...
--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)

September 15, 2010 at 11:05 pm

#1221890
RE: Are the posted questions getting worse?

CirquedeSQLeil (9/15/2010)
Alvin Ramard (9/15/2010)
Jeff Moden (9/15/2010)
Tom.Thomson (9/15/2010)
CirquedeSQLeil (9/14/2010)
Jeff Moden (9/14/2010)
CirquedeSQLeil (9/14/2010)
Has anybody else noticed that Steve is now "One Orange Chip"?
Oh lordy... I wonder what he's done to me this...
--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)

September 15, 2010 at 10:24 pm

#1221878
RE: Are the posted questions getting worse?

Despite the "lol" in the post, I really didn't like this one. Maybe it's just because I've only got one nerve left today and she decided to stand 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)

September 15, 2010 at 10:19 pm

#1221874
RE: Are the posted questions getting worse?

The Dixie Flatline (9/15/2010)
To say "yes" would be an insult to plaid goats everywhere. 😉
I'm ready to take my beating now, Mr. Jones.
BWAAA-HAAA!!! Oooohhhh lordy! That drink...
--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)

September 15, 2010 at 10:15 pm

#1221873
RE: Deterministic UDF slower than Non-Deterministic?

Jeff Moden (8/3/2010)
dant12 (8/2/2010)
yeah sure ill send you a .csv if your willing to play with it, but i wouldnt bother so much. you already gave me lots of ideas...
--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)

September 15, 2010 at 10:05 pm

#1221872
RE: Deterministic UDF slower than Non-Deterministic?

{edit} This post was related to a spam post which has since been deleted, so I've "deleted" mine. Thanks folks.
--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)

September 15, 2010 at 10:02 pm

#1221870
RE: Dynamic Quer in UDF

Craig Farrell (9/15/2010)
Jeff Moden (9/15/2010)
[rant]
Of course, I also get ticked that object names in a FROM clause can't use a variable name. If I can do it using dynamic...
--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)

September 15, 2010 at 9:56 pm

#1221868
RE: Searching for Plans

The Dixie Flatline (9/15/2010)
Jeff, you really have to let me buy you a drink at the PASS summit.
That would be both a pleasure and an honor. Thanks, Bob.
--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)

September 15, 2010 at 9:45 pm

#1221867
RE: Are the posted questions getting worse?

The Dixie Flatline (9/15/2010)
I have seen Grant (and Steve) in kilts. 'Tis na a pretty sight.
Heh... plaid goats?
--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)

September 15, 2010 at 9:35 pm

#1221864
RE: Are the posted questions getting worse?

Tom.Thomson (9/15/2010)
CirquedeSQLeil (9/14/2010)
Jeff Moden (9/14/2010)
CirquedeSQLeil (9/14/2010)
Has anybody else noticed that Steve is now "One Orange Chip"?
Oh lordy... I wonder what he's done to me this time. 😛
You're just SSC Insane
Something...
--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)

September 15, 2010 at 9:18 pm

#1221854
RE: Are the posted questions getting worse?

Tom.Thomson (9/15/2010)
Stefan Krzywicki (9/14/2010)
CirquedeSQLeil (9/14/2010)
Alvin Ramard (9/14/2010)
GilaMonster (9/14/2010)
Grant Fritchey (9/14/2010)
GilaMonster (9/14/2010)
Lynn Pettis (9/14/2010)
The key to arguing with GilaMonster (or anyone for that matter) is:
A) Admit when you are wrong.
B) If...
--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)

September 15, 2010 at 9:15 pm

#1221852
RE: Missing sequence number

Hey folks. Wayne S. found the occurance of a bug in the code that I previously posted on this thread. I've repaired that code on this thread. ...
--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)

September 15, 2010 at 8:52 pm

#1221849
RE: Patients who come in within 14 days

All these bloody "medical database" problems seem like homework to me. I know they can sometimes get a little screwy but there is just no way that the health...
--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)

September 15, 2010 at 7:56 pm

#1221837
RE: simple SELECT query takes ten seconds to return 5000 rows - can I optimize?

I know this might seem stupid to even try but it made the code run twice as fast on my machine...
SELECT
X.*
FROM X
INNER JOIN (
SELECT
...
--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)

September 15, 2010 at 7:48 pm

#1221836

Viewing 15 posts - 36,796 through 36,810 (of 59,099 total)