Jeff Moden

Forum Replies Created

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

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
RE: Problem with date type

hoanglong88i (12/16/2010)
Hello everyone,
My trouble is that I have objects stored as date type, not datetime:
Gosh... it seems to me that you've correctly identified the real problem... what keeps you from...
--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 10:56 pm

#1264478
RE: date format

MonsterRocks (12/14/2010)
TO_DATE('11/17/2005 20:51:27', 'MM/DD/YYYY HH24:MI:SS')
above function in Oracle.. wht is the equavalent in sql server for the format of date 'MM/DD/YYYY HH24:MI:SS' ?
any help pls?
I know this post is several...
--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 4:51 pm

#1264464
RE: Parent Child Relationship

brindaam (12/13/2010)
Hi,
I have two queries, say for example
Select distinct 0 parent_id, ROW_NUMBER() OVER(
ORDER BY Column2_Desc ) AS 'ID', Column2_Desc
From table1
Union
Select distinct 0 parent_id, ROW_NUMBER() OVER(
ORDER BY Column2_Desc ) AS 'ID',...
--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 4:46 pm

#1264463

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