Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,581 through 35,595 (of 59,102 total)

RE: Edit a datetime field

I agree with BitBucket on this one. If the machine is not producing the correct dates, it needs to go to the repair/calibration lab NOW! There's no telling...
--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 26, 2010 at 7:43 pm

#1266350
RE: Convince me to upgrade to 2008

Indianrock (12/26/2010)
Our primary production database is SQL 2005 Enterprise 64-bit on a Server 2008R2 active/passive cluster. I'd like to propose ( sell ) an upgrade to sql 2008...
--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 26, 2010 at 7:35 pm

#1266349
RE: Interview Que

saidapur_satish (12/26/2010)
Hi Jeff Moden,
Thanks, but i am not get properly could you explain me main things commonly what DBA will do?
Thanks & Regards
Satish Saidapur
People 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)

December 26, 2010 at 7:09 pm

#1266348
RE: How to get the TableName from within a clr trigger

SQLkiwi (12/26/2010)
Jeff Moden (12/26/2010)
I'm curious... what does such a trigger do?
The idea is usually to write a CLR trigger which can be attached to many objects, auditing the same information...
--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 26, 2010 at 7:06 pm

#1266347
RE: How to get the TableName from within a clr trigger

I'm curious... what does such a trigger 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)

December 26, 2010 at 9:09 am

#1266321
RE: The Professional Student

Well done, Steve. I wish everyone would take command of their own ship and learn something new everyday. Being a DBA or SQL Developer isn't your basic 9-5...
--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 26, 2010 at 9:06 am

#1266320
RE: Need a suggestion for using Nolock and Readpast

R.P.Rozema (12/25/2010)
This one is simply answered: don't use either of NOLOCK or READPAST in data entry applications. If your client values the correctness of the data she puts in/gets out...
--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 26, 2010 at 8:59 am

#1266319
RE: SQL2005 SP4 is here

ALZDBA (12/26/2010)
And this is soon:
Here is Cumulative update 1: support.microsoft.com/kb/2464079
Heh... and now we know why I don't install SP's just as soon as they come out. 😀
--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 26, 2010 at 8:50 am

#1266318
RE: Interview Que

saidapur_satish (12/26/2010)
Hi All,
Last week i attended a interview by telephonic, he asked a question some thing like.
If your database move Testing server to online server...
--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 26, 2010 at 8:49 am

#1266317
RE: IsStoredProcedure

I think it's there as a property so that you could "take stock" of what's in your server... sort of like what you might have to do if you were...
--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 26, 2010 at 8:43 am

#1266316
RE: retrieve min date from criteria - tricky

itfbd (12/25/2010)
Yes, you were correct as it does not meet my requirements fully..
i think i have to use cursor for my query wherein i have to filter and fetch 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 25, 2010 at 10:09 am

#1266277
RE: retrieve min date from criteria - tricky

itfbd (12/25/2010)
i think i have to use cursor for my query wherein i have to filter and fetch the data from max date for the given emp_id where A 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)

December 25, 2010 at 10:03 am

#1266276
RE: retrieve min date from criteria - tricky

Will there ever be missing dates or dates that don't start at the beginning of the month? Also, isn't there some data available before December?
--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 25, 2010 at 8:34 am

#1266275
RE: Opinions About the Design of my Database

I agree with Tom... It would appear that there is and always will be a 1:1 relationship between the fitness details, the session metrics, and the date of the session...
--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 24, 2010 at 9:05 pm

#1266259
RE: Table too large

SKYBVI (12/24/2010)
Hi,
I found out that a table in a production database is too large (23GB) and I wanted to delete some date from it. It contains 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)

December 24, 2010 at 8:08 pm

#1266258

Viewing 15 posts - 35,581 through 35,595 (of 59,102 total)