Use the following Query to find the statistics last updated date

select object_name (i.id)as objectname,i.name as indexname,i.origfillfactor,i.rowcnt,i.rowmodctr ,STATS_DATE(i.id, i.indid) as ix_Statistics_Date,o.instrig,o.updtrig,o.deltrig,o.seltrig

from sysindexes i INNER JOIN dbo.sysobjects o ON i.id = o.id

where...

Thanks for reply. We are using X86 and linked server we are using sql native client provider. we did inplace upgrade from sql server 2000 to sql server 2005. Automatically...

There is 2 linked servers and no clr.

Steven Kwong,

your issue resolved?

We did inplace upgrade to sql server 2005 and some how execution plans are corrupted in memory. That's reason i ran the foolowing commands

1. DBCC DROPCLEANBUFFERS

2. DBCC FREEPROCCACHE

After upgrade you...

I have same issue with peoplesoft Finiancial 8.4 with Sql server 2005 and peopletools 8.48.07

After upgrading sql server 2005 everything running very slow.

I ran the following commands

1. DBCC DROPCLEANBUFFERS

2. DBCC...

I verifyed with AD group and SPN is ok.

There is only one file and 4 columns on clustered index.

thnaks for helping.

I have only one file group

After reindex only i got above results. but still Extent Scan Fragmentation ...................: 31.57%

i found the answer on microsoft site

sp_dropserver <old_servername\instancename>

go

sp_addserver <new_servername\instancename> , local

go

Thanks for reply. I will try this weekend.

Regards

Ram

I drop the statistics and after that i drop the column sucessfully.but still i have one more column problem , i am trying to drop Constraint but i am getting...

it works Great. Thanks a lot jonathan

Good idea but table is very big (95 million records)and table has 49 columns.