Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,176 through 41,190 (of 59,102 total)

RE: Are the posted questions getting worse?

Alvin Ramard (11/12/2009)
I wasn't being serious when I made a comment about an article.
Jeff, Bob and I were out in the parking lot discussing what you just mentioned, about 45...
--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)

November 12, 2009 at 9:59 pm

#1078702
RE: IF statement using a Date range

trudye10 (10/26/2009)
Sorry Jeff.
I hope to one day be worthy of the title SSC Rookie
Heh... lot's of people make the same mistake. No worries.
--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)

November 12, 2009 at 9:50 pm

#1078700
RE: Milestones

rizwan.inam (11/5/2009)
Like MS PROJECT Parent Activity Start and End Date depend on Child Activities Start and End Date.
Can you be just a bit more descriptive? Are you saying 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)

November 12, 2009 at 9:43 pm

#1078699
RE: Pivoting a one column table

Ok... I'm confused. I thought you said you weren't the one responsible for importing the data.
--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)

November 12, 2009 at 9:35 pm

#1078696
RE: query suddenly goes slow - Worktable logical reads high

Can't tell just from what you posted but it has all the smackings of "parameter sniffing".
--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)

November 12, 2009 at 9:23 pm

#1078692
RE: Query to show dates in columns

Thanks for the explanation.
--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)

November 12, 2009 at 9:16 pm

#1078691
RE: Running Totals

Man, I missed this one. Sorry for the delayed answer.
The only time you need the WITH(INDEX(0)) index hint is if you're going to do something whacky like Hugo 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)

November 12, 2009 at 9:12 pm

#1078689
RE: Script all data of a table

vivek-459197 (11/7/2009)
Hi Florian,
Resolve the issue replacing -
DECLARE @select VARCHAR(MAX)
With
DECLARE @select VARCHAR(8000)
&
changing this query
SELECT @object_id = object_id, @schema_id = schema_id
FROM sys.tables
...
--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)

November 12, 2009 at 9:08 pm

#1078687
RE: Table with only one record

SQL Guy-482125 (11/9/2009)
But unfortunately our DBA's prohibit using sp_rename in production environment.
Then use a synonym and alter it to where it's pointing.
--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)

November 12, 2009 at 8:54 pm

#1078685
RE: The Multi-valued Parameters problem in Reporting Services

Naeem_Khan (11/3/2009)
I don't think there are end of line characters.
If they print on different lines, I can just about guarantee there are. 😉
--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)

November 12, 2009 at 8:49 pm

#1078682
RE: The Value of Experience

Heh... you should walk a mile in my shoes. 😉
--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)

November 12, 2009 at 8:47 pm

#1078681
RE: adding column to the table

Thanks. I appreciate the feedback. Glad it worked out for you.
--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)

November 12, 2009 at 8:31 pm

#1078677
RE: Are the posted questions getting worse?

Alvin Ramard (11/12/2009)
.... hmmmmm .... using checksum(newid()) as a random number generator.
Might be an idea for an article. 😉
IIRC, it was Bob who asked me if he could 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)

November 12, 2009 at 8:15 pm

#1078675
RE: transpose rows into columns

Heh... take a look, Lutz. The person who provided the data isn't even the OP. 😀 I'm out of here.
--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)

November 12, 2009 at 7:51 pm

#1078674
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

Ok, Martin... I'm confused... I see that all of your code examples update the "RunningBalance" column... none of the code updates the "RunningTotal" column yet your complaint is that the...
--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)

November 12, 2009 at 7:39 pm

#1078673

Viewing 15 posts - 41,176 through 41,190 (of 59,102 total)