Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,416 through 44,430 (of 59,097 total)

RE: Crosstab type report -- Horizontal Summray

Sorry... almost forgot... spreadsheets and plain text are a bit of a chore because most folks on this forum like to test their code against your good data before posting...
--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)

March 28, 2009 at 6:01 pm

#967967
RE: Crosstab type report -- Horizontal Summray

Joseph Henry (3/28/2009)
Thanks for all of the advice. I'm wondering though.. Can I use Pivot without having aggregate functions? I started to work on a select statement, but...
--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)

March 28, 2009 at 5:57 pm

#967964
RE: String Manipulation

... and here's the code, all cleaned up so it can actually be copied correctly instead of the mess the code window made. Barry, if you test compare against...
--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)

March 28, 2009 at 5:39 pm

#967961
RE: String Manipulation

Man... I just went back and looked at the code I posted... these bloody new code windows added an extra charindex, changed double spaces to single spaces, and did 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)

March 28, 2009 at 4:38 pm

#967956
RE: Just testing the new code window... please disregard

Heh... the outcome of the tests say... nothing's been done so far. BWAA-HAAA!!!! Perhaps this would be a good place to introduce folks to "agile" programming methods 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)

March 28, 2009 at 3:27 pm

#967943
RE: Just testing the new code window... please disregard

Pasted from the code window above minus the double add...
drop table tally
---===== Create and populate the Tally table on the fly
SELECT TOP 11000 ---equates to more than 30 years...
--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)

March 28, 2009 at 3:25 pm

#967942
RE: Just testing the new code window... please disregard

Just a couple of tests to see if they actually did anything for some of the fixes...
/**********************************************************************************************************************
Purpose:
Returns a single result set similar to sp_Space used for all user...
--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)

March 28, 2009 at 3:23 pm

#967941
RE: Do DBAs Still Read Techincal Books?

sqlblue (3/28/2009)
Jeff, you probably don't remember, but you helped me once...
Anytime someone gives me such an awesome compliment, I'm compelled to go find out what I did right and 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)

March 28, 2009 at 11:45 am

#967910
RE: Do DBAs Still Read Techincal Books?

Steve Jones - Editor (3/28/2009)
Jeff,
I think there's a good call for a T-SQL book from you 🙂
The other thing is that most authors aren't thinking performance when they write. 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)

March 28, 2009 at 11:23 am

#967903
RE: Do DBAs Still Read Techincal Books?

sqlblue (3/28/2009)
Jeff, you probably don't remember, but you helped me once, and I have a tremendous
respect for your technique, knowledge, and for helping me.
I really think you should write...
--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)

March 28, 2009 at 11:04 am

#967900
RE: Do DBAs Still Read Techincal Books?

Heh... all of these conversations have made me revisit some of the books I did buy including some of the ones being talked about. And THAT made me realize...
--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)

March 28, 2009 at 8:18 am

#967878
RE: Are the posted questions getting worse?

Lynn Pettis (3/27/2009)
Jeff Moden (3/26/2009)
Lynn Pettis (3/26/2009)
You must answer with no foul or abusive language.
BWAA-HAAA!!! ... who the hell made THAT rule? This IS the thread. 😉
Well, I think...
--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)

March 27, 2009 at 9:32 pm

#967824
RE: Do DBAs Still Read Techincal Books?

Grant Fritchey (3/27/2009)
Jeff should do it.
"Pork Chops for the DBA" by Jeff Moden
"SQL Server Performance Tuning by Pork Choping Deveopers" by Jeff Moden
"Better Performance by True Set Based Operations 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)

March 27, 2009 at 6:39 pm

#967810
RE: Do DBAs Still Read Techincal Books?

Steve Jones - Editor (3/27/2009)
Maybe we need a poll to push Jeff along 😉
Heh... I know you... with all the talk of ancient weapons by the Ninja's on this forum,...
--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)

March 27, 2009 at 6:37 pm

#967808
RE: Do DBAs Still Read Techincal Books?

Gift Peddie (3/27/2009)
I remember a while back Jeff said we (SSC) should write a book in Performance when I said Microsoft hired some one who did not know the difference...
--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)

March 27, 2009 at 6:10 pm

#967805

Viewing 15 posts - 44,416 through 44,430 (of 59,097 total)