Jeff Moden

Forum Replies Created

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

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
RE: Lost New Line Character Error Described

dbuendiab (11/9/2010)
(Already posted in General 2K5 Forum, posted again here - maybe more adequate place)
I've been near to send a post to the world on this issue I've been fighting...
--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 12:00 pm

#1266238
RE: Jump to 2008 or stick with 2005 (partially done)?

As you said, either way you still end up preping for and taking two exams. Why not take the latest and greatest?
--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 11:52 am

#1266237
RE: How to do UNPIVOT with dynamic column names within a FUNCTION

nemesis52 (12/23/2010)
Hi Jeff,
Because there is just one admin who has permission and is responsible to enter basic definitions like antibiotics, I am not really worry about the issue you mentioned.
Thanks...
--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 23, 2010 at 8:42 pm

#1266120

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