Hi All ,

fitst you need to disable all maintenance plan   , perhaps your rebound or organise process all table without considering fragmentation .

also tha sal server audit can help...

hi All,

When maintenace tables is running it will update stats in these DMV, that is not a production usage , we can't eliminate it , so we can't declare the...

i'am sorry, it is just one error of copy/past the good script is:

/*

Author: rabie harriga

Version:SQL 2005, 2008, 2008 R2

Decription:This Script allows you to determine the list of unused indexes in...

select object_name (i.object_id) as NomTable,isnull( i.name,'HEAP') as IndexName

from sys.objects o inner join sys.indexes i

ON i.[object_id] = o.[object_id] left join

sys.dm_db_index_usage_stats s

on i.index_id = s.index_id and s.object_id = i.object_id

where object_name...

i think that you have a licence problem

the duration is the time CPU end the time for read or write from buffer or from disk.

You can capture the excution plan for see the difference between plans.

If the...

this way is not exact, because when you type sqlcmd -E you will obtain à time out for sql connexion because your account dont existe in sys.logins.

In the case when...

this way is not exact, because when you type sqlcmd -E you will obtain à time out for sql connexion because your account dont existe in sys.logins.

In the case when...

this way is not exact, because when you type sqlcmd -E you will obtain à time out for sql connexion because your account dont existe in sys.logins.

In the case when...

this way is not good, because yoiu dont have the permission to connect just with sqlcmd -E, this way is not excat.

You must add your login to local group created...