hi

I agree that if i am not using referential integrity i will be ending with dirty data. But when thedb is structured as no master record deletion and having...

I didnt say index is a replacement for foreign key. I says that query performance depends on the indexes not on referential integrity components. even it helps in generating a...

hi

We mostly do bulk loads in our databases. nearly a lakh data will get inserted/updated in our databases everyday.

In those cases, fk relationship will degrade the insert/update operation. We...

hi

I have a debate over this concept.

Foreign key and check constraints are referential integrity components. How we can say this will increase the query performance.

Yes it may increase the...

hi

Developer and enterprise editions are same. but we should not use developer edition on production server

Also, developer edition can be used for development/testing/demo.

Refer this site for more details

hi

Thanks for your reply. but we cannot do that because we do have more columns for some other purpose and we cannot expect that proc to return all those columns.....

hi

This is my way..

declare @date varchar(100)='201012'

select convert(varchar(6),dateadd(M,1,convert(date,@date+'01')),112)

do you want the first occurence of that sum in a running total?

hi

i think you got the answer from lowel..

hi

do you want running total??

hi

why not this

DECLARE @amount float

SET @amount=9

DECLARE @table TABLE (ID int, Amount float)

INSERT INTO @table VALUES(1, 1.00)

INSERT INTO @table VALUES(2, 2.33)

INSERT INTO @table VALUES(3, 3.67)

INSERT INTO @table VALUES(4, 4.00)

INSERT INTO @table...

Thanks for your reply.

Can you tell me how to read the execution plan. any links please..

hi

You connected the server to the mirroing monitor using ip address or servername. If ip address change it to server name

Hi

By any chance did you change the sql server agent process account using windows service manager?

hi

did you change the server role by any chance. Check whether you are able to access msdb database with the login specified to run the job at the agent

Regards

VMSSanthosh