Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,386 through 23,400 (of 59,099 total)

RE: create alert for rebuild index job

Just a head's up... it's very possible that the extra 1TB isn't going to be enough if you do the rebuild while in the FULL recovery mode. It'll create...
--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)

June 20, 2014 at 9:42 am

#1723642
RE: Difference Between cross apply and cross join

daniarchitect (6/19/2014)
bitbucket-25253....wasted my time what a response
BWAA-HAA!!! Considering that you even went back and edited your response, I suspect you voluntarily wasted more time on your own that what 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)

June 20, 2014 at 9:27 am

#1723636
RE: Rebuild Indexes not working

zedtec (6/20/2014)
Hi,
I have a maintenance plan which rebuilds indexes on ALL databases on my instance. I'm running SQL Server 2008 R2 and it is fully up to date with it's...
--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)

June 20, 2014 at 9:21 am

#1723632
RE: Generating dynamic dates from stored parameters/criteria

D. Clark (6/19/2014)
Hello all,
Not sure if this is the best forum for this but since it is in the realm of testing I thought I would try here first. 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)

June 20, 2014 at 9:17 am

#1723631
RE: problem .... income during month in sql server 2008

amr.moussa.87 (6/19/2014)
i have tried many thing
i have table called visiting, it have two column (visiting date) and ( cost ) like that
visiting_date ...
--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)

June 19, 2014 at 11:35 pm

#1723465
RE: Unwelcome posts on our forums

You folks have always been the best. Thanks for all the you've done and are getting ready to 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)

June 19, 2014 at 11:22 pm

#1723462
RE: Just curious, what are your SQL pet peeves ?

Ed Wagner (6/19/2014)
andrew gothard (6/19/2014)
below86 (6/18/2014)
andrew gothard (6/18/2014)
below86 (6/16/2014)
andrew gothard (6/15/2014)
Koen Verbeeck (6/14/2014)
Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you 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)

June 19, 2014 at 4:32 pm

#1723439
RE: Counting the characters in a string before a space

Eirikur Eiriksson (6/19/2014)
Jeff Moden (6/19/2014)
My problem is that I really don't understand what you're trying to do. This start out with "counting characters in a string before a space"...
--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)

June 19, 2014 at 4:21 pm

#1723438
RE: How to start Perf improvement

ramana3327 (6/19/2014)
Hi Kevin,
Mostly I work in the dev or testing box only. So it is ok to run the profiler
Considering all of the performance related questions you've been asking lately,...
--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)

June 19, 2014 at 1:01 pm

#1723409
RE: Counting the characters in a string before a space

My problem is that I really don't understand what you're trying to do. This start out with "counting characters in a string before a space" and I showed 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)

June 19, 2014 at 8:38 am

#1723287
RE: Counting the characters in a string before a space

So I don't have to do all of that just to see, what do you get as an output from all of 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)

June 18, 2014 at 3:44 pm

#1723017
RE: Are the posted questions getting worse?

SQLRNNR (6/17/2014)
GilaMonster (6/17/2014)
SQLRNNR (6/17/2014)
The Dixie Flatline (6/17/2014)
GilaMonster (6/17/2014)
Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others"
"No pressure 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)

June 18, 2014 at 10:50 am

#1722887
RE: True Or False?

Sean Lange (6/18/2014)
Even better would be to get rid of that cursor entirely. From what you posted I don't see a need for a cursor. If you want help 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)

June 18, 2014 at 8:08 am

#1722819
RE: Just curious, what are your SQL pet peeves ?

below86 (6/18/2014)
Jeff Moden (6/18/2014)
below86 (6/18/2014)
andrew gothard (6/18/2014)
below86 (6/16/2014)
andrew gothard (6/15/2014)
Koen Verbeeck (6/14/2014)
Badly phrased, sorry. In a column that should be a date, it's plain stupid (if you do 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)

June 18, 2014 at 8:06 am

#1722816
RE: Drop Identity column from temp table

Cool. How'd you do it?
Also, please don't erase the original post you posted. It's good to see a better description of the problem than only that which is...
--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)

June 18, 2014 at 7:48 am

#1722802

Viewing 15 posts - 23,386 through 23,400 (of 59,099 total)