Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,766 through 36,780 (of 59,072 total)

RE: Critical issues detected by SQL Server BPA

Mark Enloe (9/15/2010)
Manu-J... thanks for your straightforward, helpful response. Some others on the site appear to be more interested in providing condescending, pompous replies that do nothing to help...
--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 16, 2010 at 4:41 am

#1222039
RE: Are the posted questions getting worse?

Paul White NZ (9/16/2010)
The final part of my optimizer series is up today. As expected, the page views have been lower than normal, but it has been good to...
--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 16, 2010 at 4:27 am

#1222029
RE: Are the posted questions getting worse?

Paul White NZ (9/15/2010)
Jeff Moden (9/15/2010)
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...
--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 16, 2010 at 4:26 am

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

Viewing 15 posts - 36,766 through 36,780 (of 59,072 total)