thank you.

Please check this...

update <table name> set name = SUBSTRING (name,3,len(<column name>)) where SUBSTRING(<column name>,1,2)='NA'

check this ...

Declare @Param_Start date,

@Param_End date

select @Param_Start=DATEADD(DD, 2-DATEPART(DW, '2012-11-01'), '2012-11-01'),

@Param_End='11/11/2012'

;with cte1(date1)

as

(

select convert(date,@Param_Start)

union all

select DATEADD(week,1,date1) from cte1

where date1<=@Param_End

)

select * from cte1

try this...

with cte1(date1)

as

(

select convert(date,'2012-11-05')

union all

select DATEADD(week,1,date1) from cte1

where date1<='2012-11-20'

)

select * from cte1

thanks lot

Please help us

No, please try this

alter table Atest drop constriant PK_ATest

alter table Atest alter column id bigint

alter table Atest add constriant PK_Atest primary key clustered (id)

Hi,

Any idea?

Either we can use lock hint based on sensitive of data or Non Clustered Index which will create addition maintenance work. My choice is Non Clustered index.

can you tell me size of tableA and execution time for the below query?

SELECT * from FROM tableA

UPDATE A SET A.IsError=1 FROM Table1 A LEFT JOIN Table2 B ON B.Id=A.Id...

Thanks All,

Yes, I tested that it distributed data equally for all the files. My doubt is, whether it is possible to do file level partition.

post your sql scripts..

we fixed the issue.

Problem is , we have snapshot database which recreated every 15 mins. So my procedure is getting this error

Thanks for all..

we did not change db settings and used separate service account with sysadmin rights.

Hi,

Thanks lot, it is working...