Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,626 through 35,640 (of 59,102 total)

RE: Pause the query

ravisamigo (12/20/2010)
Dear All,
Is there any option to pause the query and resume later if it takes more time to finish?
Please advise.
Thanks and Regards,
Ravichandra.
IF somecondition is true WAITFOR TIME 'hh:mm:ss'
Of course,...
--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)

December 20, 2010 at 8:53 pm

#1264867
RE: Fastest way to move a database from 32bit to 64bit server

DKlein (12/20/2010)
It is going from a raid 5 to a raid 5, from box to box. From 32bit (publisher) to 64bit (subscriber).
Thanks again,
DK
Now would be a good time 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)

December 20, 2010 at 8:50 pm

#1264866
RE: Expected salary for DBA with 3 years exp.

SKYBVI (12/20/2010)
this thread is 15 months old..
the figures would change now as that time it was recession and
now the market is growing very fast..
Regards,
Sushant
DBA
West Indies
heh... didn't even look. ...
--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)

December 20, 2010 at 8:49 pm

#1264865
RE: Expected salary for DBA with 3 years exp.

free_mascot (9/17/2009)
If I am not wrong in India at present you can ask around 20% more on the currnet salary.
But still Depend on Company, requirement, roles & responsibilities etc....
WHAT "current...
--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)

December 20, 2010 at 8:43 pm

#1264864
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/20/2010)
WayneS (12/20/2010)
Ray K (12/20/2010)
Celko warning alert
But the OP blasted him right back
Yeah, I really liked how the OP pointed out that all Celko's assumptions were wrong. He seems...
--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)

December 20, 2010 at 8:41 pm

#1264863
RE: DateDiff on Consecutive Rows

bhutchin (12/20/2010)
Charles - Thank you very much. This is exactly what I was looking for.
@bhutchin,
I'm asking for reasons of performance, present or future. How many rows do you have...
--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)

December 20, 2010 at 8:37 pm

#1264862
RE: DateDiff on Consecutive Rows

Matt Miller (#4) (12/20/2010)
Wildcat (12/20/2010)
That is for DELETE or UPDATE statement, not for the SELECT.
BTW, how could a NOLOCK hint to the target table on the DELETE or UPDATE statement?...
--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)

December 20, 2010 at 8:27 pm

#1264861
RE: Getting ethnicity information - multiple columns to single column

Also, if you do go to a "BIT" map on this, you should really consider a binary numbering scheme to support actualy "Bit Level Math". 1 = CAUCASIAN, 2...
--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)

December 20, 2010 at 8:13 pm

#1264860
RE: Getting ethnicity information - multiple columns to single column

torpkev (12/20/2010)
I need to translate this into a single column...
Heh.. your request has people speaking of BIT maps, Cursors, and other basic "Worlds-of-Pain" . With that in mind, would...
--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)

December 20, 2010 at 8:09 pm

#1264859
RE: how to use if-else condition in store procedure with insert,update,delete,reader with example

CELKO (12/20/2010)
Can you be more vague ? 😀
Heh... on that subject, you said a while back that you were working on the 2nd edition of the "Trees and Hierarchies in...
--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)

December 20, 2010 at 8:01 pm

#1264858
RE: how to use if-else condition in store procedure with insert,update,delete,reader with example

Satishsingh9080 (12/20/2010)
how to use if-else condition in store procedure with insert,update,delete,reader with example
please rply this example
Once you've read the link that Sean gave you, you may actually want to try...
--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)

December 20, 2010 at 7:59 pm

#1264856
RE: Problem while updating column through trigger

pankaj.nainu1 (12/19/2010)
Ooookkkkk... so why the heck do you need error prone sequence logic in a RBAR trigger if you have an identity column in the table? This makes no sense...
--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)

December 20, 2010 at 9:06 am

#1264665
RE: WHERE...IN vs JOIN

Mad Myche (12/20/2010)
I read through this and the first thing I thought of was using fn_Split to break up the List, I wonder if his fn_IntListToTbl is some derivative...
--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)

December 20, 2010 at 9:04 am

#1264664
RE: Problem while updating column through trigger

pankaj.nainu1 (12/19/2010)
The strange thing is that I do have an identity column in the table which does not have any skips. What comes to my mind is that in 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)

December 19, 2010 at 11:31 pm

#1264484
RE: date format

Perfect. Thanks for the feedback. 🙂
--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)

December 19, 2010 at 11:28 pm

#1264482

Viewing 15 posts - 35,626 through 35,640 (of 59,102 total)