Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,771 through 46,785 (of 59,095 total)

RE: Cascading parameter dropdowns

Heh... why does everyone blame dynamic SQL... that's not what makes these drop downs painfully slow. Poor intial design, lack of proper indexes, and non-sargable SQL is what makes...
--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)

December 6, 2008 at 4:07 pm

#908856
RE: PIVOTS and TRANSFORMS

Thanks Ron :blush:
--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)

December 6, 2008 at 4:01 pm

#908854
RE: New To SQL Server / Help Starting

Start here...
http://www.sqlcourse.com/
... then move to Books Online which comes free with SQL Server... concentrate on the "Contents" tab.
SQL Server is a big subject... don't try to learn it all at...
--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)

December 6, 2008 at 3:57 pm

#908852
RE: Data Vices

Good enough... Lord knows why I started back up after quitting twice for a year, but, both times, I still went to the smoking deck... smoking or not, people seem...
--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)

December 6, 2008 at 3:42 pm

#908850
RE: Power and Deception of CTEs

timothyawiseman (12/6/2008)
Jeff Moden (12/6/2008)
timothyawiseman (12/5/2008)
To slightly modify a quote from Larry Wall, "SQL is designed to give you several ways to do anything, so consider picking the most readable one."
I'm...
--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)

December 6, 2008 at 3:38 pm

#908849
RE: Automating Excel from SQL Server

ricol (12/5/2008)
I have heard this story before, and before and before.
Still my stuff runs stable!!! All nights all year around.
So why all these bad stories, show me the proof!! 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)

December 6, 2008 at 11:12 am

#908832
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Judy (12/5/2008)
From here I learn how to use Tally table, QuoteName, Grouping.
Thank you!:D
Thank YOU! I absolutely love feedback like this. I love to teach and I love 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)

December 6, 2008 at 9:33 am

#908823
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Christopher Stobbs (12/5/2008)
you might be surprised but I think just the way that you shared some of you own style and techniques in this article really opened up my knowledge...
--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)

December 6, 2008 at 9:30 am

#908822
RE: The Exceptional DBA: Soft Skills

crainlee2 (12/5/2008)
Tony,
I am starting to see a lot of job requirements listings like this for DBAs, system admins, and software developers.
We know, and some managers know, that no one has...
--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)

December 6, 2008 at 9:05 am

#908818
RE: Recommended path for advanced training?

That's a pretty good analogy of the differences between set based and cursors. Now, I know why you write books. 🙂 Well, done, Brandie!
--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)

December 6, 2008 at 8:29 am

#908813
RE: Processing a non-locked row update from within a TRANSACTION

John Barry (12/4/2008)
Jeff,
This is great. You're awesome - thanks so much for your help. Death to RBAR !!!
Regards,
John
Sorry, John... I got way behind on my emails...
First, thanks for...
--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)

December 6, 2008 at 8:23 am

#908811
RE: Power and Deception of CTEs

timothyawiseman (12/5/2008)
To slightly modify a quote from Larry Wall, "SQL is designed to give you several ways to do anything, so consider picking the most readable one."
I'm definitely for 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)

December 6, 2008 at 8:18 am

#908810
RE: Look up a table fields, data type, etc.

bitbucket (12/5/2008)
Jeff
Pickle juice or formaldehyde? With or without pork chops?
Worked on that SP long before I hand the pleasure and enlightenment of reading your articles, and learning from...
--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)

December 6, 2008 at 8:09 am

#908809
RE: Convert Rows to columns so...

fausto usme (12/5/2008)
>>Heh... No matter where it's done, I'll still like to know why the BA thinks >>that listing an unknown number hospital rooms horizontally is the right thing >>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)

December 5, 2008 at 9:12 pm

#908751
RE: Data Vices

pmcpherson (12/5/2008)
I ahve noticed that 2 smokers who don’t know each other will at least say “Hi” when standing next to each other outside. Two non-smokers can sit next...
--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)

December 5, 2008 at 5:23 pm

#908728

Viewing 15 posts - 46,771 through 46,785 (of 59,095 total)