Hi SQLArcher, thanks for reply..

AD Team has created SQLCluster Object name in domain after that It was brought online.

Thank you for reply.. please tell me, I had mention some points are in first post for cluster configuration. these are correct or not? Does whatever user database in Node...

Thanks for reply...

I understand for IO never become 0.0.

Could you tell me, what is actual value output for most IO query and what is generally perfered value of IO in...

Hi,

Can we give database_role, db_owner for normal sqlserver user and application user?

Please tell me, default database owner and schema "dbo", could assign normal and application user?

How to assign least premission...

Hi,

Thanks for reply....

Please find attached xls sheet for unused index details and other index used status.

For the used index values are available for user_seek, user_scan, and unused index...

hi,

I have attached unused index three report for using three different script. all are showing different values, Could anyone suggestion me which is the best script and go for it.

Thanks...

[The user_updates counter indicates the level of maintenance on the index caused by insert, update, or delete operations on the underlying table or view. You can use this view to...

Thanks for clarification and reply...

One more doubt for LOCK PAGE MEMORY setting. (memory swapping)

win 2008 enterprise edition, 32 bit or 64 bit. Is it required to enable lock page memory...

Thanks for reply....

Ok, I should change and setting max memory in SQLSERVER Instance.

If server 4 GB RAM, how much I should allocated for max memory?

One more doubt, pl. calrify ,If...

Hi,

1. AWE is not enabled,

2. Default memory configuration, Manually not setting max memory.

Thanks

32 bit OS, OLTP Transaction.

No, I am not tried DBCC...

Thank you so much....

Now query result is cleared & also my doubut.

thanks Gila for reply..

Could you tell me, again one null values this output in column of type_desc.

what is this excatly mention database?

TypeNoOfObjecttype_desc

D 31DEFAULT_CONSTRAINT

FN4SQL_SCALAR_FUNCTION

IT5INTERNAL_TABLE

P 36SQL_STORED_PROCEDURE

PK21PRIMARY_KEY_CONSTRAINT

S 45SYSTEM_TABLE

SQ3SERVICE_QUEUE

U 29USER_TABLE

UQ175NULL

UQ1UNIQUE_CONSTRAINT

Understood about the heap index statistices, Mr. Grant told me Heap index does not have maintain statistices.

Please sugesstion & give me script For the heap index to change the non...

Thanks for reply..

This is script for find out last stats updated date.

select a.id as 'ObjectID', isnull(a.name,'Heap') as 'IndexName', b.name as 'TableName',

stats_date (id,indid) as stats_last_updated_time

from sys.sysindexes as a

inner join sys.objects as...