Problem is need to check other table stats and will update it. not in RESULT table stats.

as per query that well parameterized and again index seek 50 %.. please explain...

I modified Query as per your suggestion and fetching result 00 seconds..But NC clustred index seek 50% and .. what could be issues?, Need to change index column? and all...

thanks for reply... I got the result 00:00:00 seconds after update stats in NC Clustred Index in RESULT Table..

yes, we are using windows 2008 operating system...

SQL Service account running under windows local users.. But domain users are added into SQL logins for connection between database and application...so in...

thank you Mr. Johan,

I have tested multiple primary key in single table.

PK - columname 1 - [id_no]

PK - columname 2 - [id_nos]

ALTER TABLE [dbo].[Index_testing] ADD CONSTRAINT [PK_Index_testing] PRIMARY KEY CLUSTERED

(

[id_no]...

SSIS pakages automatically loaded and created by when configure database backup thru Mnagement plan wizard...it may be cause currpted some dll files realted to DotNet 2.0 framework.... after restarting backup...

DELETE statement will be hang due to 76554566 total records.. any suggestion Pls.

Hi,

Thanks for your help.. I had successfully updated CU1 on SQL2K8R2 64 bit.

File name downloaded: SQLServer2008R2-KB2720425-x64

Existing Version: SQL2K8R2 SP2 version - 10.50.4000

Current version: SQL2K8R2 SP2 CU1 version - 10.50.4260

I have...

Thanks for reply .. please confirm

I have download file name is : SQLServer2008R2-KB2720425-x86, it can apply for 32 bit not for 64 bit..

I could not able to download 64 bit...

Thanks for reply.. could you pl.confirm which patch number should be download?

(http://support.microsoft.com/kb/2720425/ )

2720425

Cumulative Update package 1 for SQL Server 2008 R2 Service Pack 2

2703280

Cumulative Update package 14 for SQL...

In SQL SERVER 2008 R2 64 bit, I had installed SP2, Not for CU1..

should I download SP2 CU1 and apply that patch..?

thanks

ananda

Thanks for your suggestion... First, I am going to install on dev setup after tested everything..then going for production setup...

Currently standard edition with SP1..I have doubts, can install sp3 before...

Thanks for reply.. some of the index result showing as below, it is treated as used index?

Index A

UserSeek - 193121

UserScans - 0

UserLookup- 0

UserUpdates - 49183

Index B

UserSeek - 0

UserScans - 0

UserLookup-...

Could you seems that error log file, which I was posted

I have ceate one table for storing output according timestamp as per that query result and schedule it every 15...