Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,786 through 43,800 (of 59,097 total)

RE: Are the posted questions getting worse?

Jack Corbett (5/13/2009)
Here's an almost textbox example of how to post a question:
http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/76211536-6cbb-4e68-b7c5-b64b83ba0dde
The only issue is that he used C# to populate the table, but at least he did something.
Either...
--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)

May 13, 2009 at 3:48 pm

#994159
RE: Are the posted questions getting worse?

Steve Jones - Editor (5/13/2009)
wouldn't VMs come into the memory area?
Jeff, I'd think 64bit and Hyper-V. I've had quite a few other MVPs say they like this arrangement since 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)

May 13, 2009 at 3:46 pm

#994157
RE: Are the posted questions getting worse?

All good stuff about the laptops folks. Thanks. I'll let you know what I end up 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)

May 13, 2009 at 11:06 am

#993919
RE: Performance issue with tally solution

Paul White (5/12/2009)
I believe he is referring to the (...FOR XML PATH('')).value('./[1]') nastiness.
Embed a non-printable character to blow this one up.
RBarryYoung (5/12/2009)
When you are using FOR XML 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)

May 12, 2009 at 9:48 pm

#993412
RE: Are the posted questions getting worse?

I'm finally going to break down and buy a laptop (computer, that is 😛 ). I'd prefer a 17" display but will go with a decent 15" display. ...
--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)

May 12, 2009 at 9:41 pm

#993410
RE: Are the posted questions getting worse?

Heh... I finally found a video to use at the beginning of any seminars I may have the good fortune to speak at...
http://www.youtube.com/watch?v=amICZ1aVaCg
--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)

May 12, 2009 at 9:27 pm

#993407
RE: Are the posted questions getting worse?

Alvin Ramard (5/12/2009)
Jeff Moden (5/12/2009)
Alvin Ramard (5/12/2009)
How many point will I get if I post that video of Bob playing the banjo and signing his song?
😀
Minus 50 😀
Even if 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)

May 12, 2009 at 9:04 pm

#993400
RE: indian authors for sql server book

Heh... get any on ya, Barry? 😛
--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)

May 12, 2009 at 9:00 pm

#993399
RE: Are the posted questions getting worse?

john.arnott (5/12/2009)
It's an interesting series of posts from the latest pork chop target.
What's the link for that one, John?
--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)

May 12, 2009 at 8:34 pm

#993392
RE: Are the posted questions getting worse?

Alvin Ramard (5/12/2009)
How many point will I get if I post that video of Bob playing the banjo and signing his song?
😀
Minus 50 😀
--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)

May 12, 2009 at 8:31 pm

#993391
RE: indian authors for sql server book

Paul White (5/12/2009)
Jeff Moden (5/12/2009)
Paul White (5/12/2009)
Jeff Moden (5/12/2009)
It pays to be polite and clear to people in all walks of life whether you expect to gain knowledge from them...
--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)

May 12, 2009 at 7:14 pm

#993369
RE: indian authors for sql server book

Paul White (5/12/2009)
Jeff Moden (5/12/2009)
It pays to be polite and clear to people in all walks of life whether you expect to gain knowledge from them or not.
Oh zark off...
--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)

May 12, 2009 at 6:41 pm

#993365
RE: Performance issue with tally solution

UMG Developer (5/12/2009)
Jeff Moden (5/11/2009)
Once you recognize the "pattern", you don't need all the ancillary conditional data moves and deletes. The "pattern" is that if it's NOT a continuation...
--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)

May 12, 2009 at 6:28 pm

#993361
RE: Performance issue with tally solution

David Burrows (5/12/2009)
Nice one Jeff 😎
Thanks, David. I didn't understand the problem until I saw the test data (funny how important that is :-D). Thought we could do...
--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)

May 12, 2009 at 6:25 pm

#993360
RE: Performance issue with tally solution

UMG Developer (5/12/2009)
Jeff,
Now you've essentially got my roll it up and then split it method that takes ~2 minutes for the roll up, and ~16 minutes for the split. 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)

May 12, 2009 at 6:18 pm

#993359

Viewing 15 posts - 43,786 through 43,800 (of 59,097 total)