Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,111 through 46,125 (of 59,095 total)

RE: Prduction DBA

pavankumarh2 (1/5/2009)
Dear Friends ,
I am moving to work on Production support as DBA ,plz any tell me any body what are the common responsibilities 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)

January 6, 2009 at 5:48 am

#921696
RE: date format problem

My very strong recommendation would be that both queries are wrong simply because of the use of BETWEEN. In the first query, you miss out on a whole second...
--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)

January 6, 2009 at 5:45 am

#921691
RE: Temp tables vs. table variable speeds, temp tables faster???

My general rule of thumb is to never use table variables unless the system forces me to. That means the ONLY place I use them is in UDF's.
The reason...
--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)

January 6, 2009 at 5:34 am

#921685
RE: Please help converting decimal (9) to string without decimals

What's simple about any of that? And, like Luke said, why would you convert a perfectly good number to a VARCHAR?
If you want to leave it as a number...
CAST(yournumber...
--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)

January 6, 2009 at 5:19 am

#921675
RE: Parse string based on value in another table

And, you want it to be case sensitive?
--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)

January 5, 2009 at 8:47 pm

#921551
RE: number of records added to a table over a period of time

Sounds odd, I know... but do you have a place where you could restore a 3 month old backup so you could do a compare with the current table? ...
--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)

January 5, 2009 at 8:46 pm

#921550
RE: Alternatives to xp_cmdshell for Folder Directoy

JuanBob (1/5/2009)
I need to retire our usage of xp_cmdshell. I use this for 3 different purposes, the most prevalent being using the DIR command in order to retrieve 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)

January 5, 2009 at 8:39 pm

#921548
RE: Looking Forward

Thanks, Chris!
--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)

January 5, 2009 at 8:09 pm

#921547
RE: getting all records between 2 fridays of a given date

jcrawf02 (1/5/2009)
Nice, that makes me feel better. I was wondering as I was posting how I was noticing something that Jeff missed. Luckily, I can always count on him setting...
--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)

January 5, 2009 at 8:06 pm

#921546
RE: The Year in Review 2008

Hadn't thought of it THAT way... heh... it sounds like a pretty good place to build a straw man doc, as well. 🙂
--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)

January 5, 2009 at 8:02 pm

#921544
RE: User Defined Function: order by won't work

tfifield (1/4/2009)
For what it's worth, the only way I've been able to get around the ORDER BY problem in derived tables and functions is to create an index and then...
--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)

January 5, 2009 at 7:44 pm

#921538
RE: Cursors Be Gone!

Matt Whitfield (1/5/2009)
not afaik but Jeff will correct me if there is a way to do it.
You can create a unique constraint across multiple columns, but not a clustered index...
--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)

January 5, 2009 at 7:32 pm

#921537
RE: Cursors Be Gone!

david.rowland (1/4/2009)
I think they {cursors} still have their place
Ok, I'm all for opposing opinions because that's what makes good discussions and I learn something from every single discussion.
Now, for 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)

January 5, 2009 at 7:25 pm

#921534
RE: Cursors Be Gone!

TheSQLGuru (1/4/2009)
Bottom line: DO NOT USE THIS UPDATE @var ... TRICK UNLESS YOU a) DON'T CARE ABOUT GETTING INCORRECT RESULTS OR b) YOU ARE VERY KNOWLEDGEABLE ABOUT YOUR SYSTEM,...
--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)

January 5, 2009 at 7:18 pm

#921532
RE: Cursors Be Gone!

I've gotta agree with Kevin on the table variable thing. The only reason I'll ever use table variables is if I have to make a temporary storage area 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)

January 5, 2009 at 7:05 pm

#921531

Viewing 15 posts - 46,111 through 46,125 (of 59,095 total)