Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,391 through 42,405 (of 59,102 total)

RE: Need a Line Seperator Between Data

The only problem with that is, stuff doesn't line up when you print action characters.
--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)

August 11, 2009 at 12:33 pm

#1037656
RE: Shrinking file grows again

Shrinking the file after doing a reindex just messes things up because the shrink moves pages.
--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)

August 11, 2009 at 12:20 pm

#1037649
RE: Need a Line Seperator Between Data

Ok... although a nifty trick, the problem with using something like COMPUTE BY for this is that it returns multiple result sets. I can see the need for 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)

August 11, 2009 at 12:03 pm

#1037638
RE: Need a Line Seperator Between Data

JC (8/11/2009)
Thanks Drew
but i guess we differ in opinion as I have been writiung Oracle SQL for many years and I do not quite understand whay i should not be...
--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)

August 11, 2009 at 11:49 am

#1037631
RE: Need a Line Seperator Between Data

drew.allen (8/11/2009)
You shouldn't be doing formatting in T-SQL. You should be using a formatting tool like SSRS.
You can trick T-SQL into doing this by adding a COMPUTE BY clause...
--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)

August 11, 2009 at 10:31 am

#1037583
RE: Twenty tips to write a good stored procedure

Lynn Pettis (8/11/2009)
mtassin (8/11/2009)
Lynn Pettis (8/10/2009)
mtassin (8/10/2009)
I'm sure she wasn't hinting at you. I am pretty sure I have an idea or two who she was thinking about as...
--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)

August 11, 2009 at 9:26 am

#1037513
RE: There's a Lot to Learn From Even Simple Puzzles

Phil and Joe, thanks for having that contest. There was a huge amount of participation, debate, and code comparison! I know you guys had to spend a heck...
--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)

August 10, 2009 at 10:46 pm

#1037227
RE: There's a Lot to Learn From Even Simple Puzzles

Congratulations Barry! Now, I've gotta go see what the hell you did! 😛
--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)

August 10, 2009 at 10:35 pm

#1037224
RE: Query with aggregate Function

saurabh.dwivedy (8/10/2009)
It would be instructive to familiarize yourself with Question Posting Best Practices. They do help get a speedier and more efficient response 🙂
Heh... good idea but if you're going...
--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)

August 10, 2009 at 10:31 pm

#1037222
RE: Carrying Value Across Rows

Gabriel P (8/10/2009)
Hey everyone, thanks for your posts. You all will probably be dissappointed but I've decided to instead use .Net (either via SSIS's Script Task or a Client App)...
--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)

August 10, 2009 at 10:26 pm

#1037220
RE: Carrying Value Across Rows

saurabh.dwivedy (8/10/2009)
I am truly honored to hear the good words from you, Jeff. It's a big encouragement and kind of vindicates my decision of posting my code (I had debated...
--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)

August 10, 2009 at 9:24 pm

#1037206
RE: Query with aggregate Function

Ok... I didn't make the assumption that ID1 actually contained the correct order in the table that you wanted to do the running total in. And, for a complete...
--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)

August 10, 2009 at 9:12 pm

#1037204
RE: Query with aggregate Function

Viky,
You're really new to this forum so I have a suggestion... Take a look at the following article for how to post a problem... it'll help you get fully...
--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)

August 10, 2009 at 8:18 pm

#1037195
RE: Query with aggregate Function

Matt Wilhoite (8/10/2009)
This is doing 2 table scans so I know it isn't the most efficient code. You could probably put this into a CTE and get better performance...
--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)

August 10, 2009 at 8:13 pm

#1037194
RE: Shrinking file grows again

balbirsinghsodhi (8/10/2009)
I have partition on one of the table in which data is distributed to different filegroups. for example. I believe that these filegroups would not get updated because of...
--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)

August 10, 2009 at 8:05 pm

#1037192

Viewing 15 posts - 42,391 through 42,405 (of 59,102 total)