How to find exactly that these Statistics are up to date and these Statistics are outdated?

thanks

Hi,

I have ran the below Query in 'Mydb' database to find out the out of date statistics and I found that all the statistics were 15 days old. The Auto...

thanks you,

how to find if the statistics are out of date? As our indexes are not getting fragmented, so I'm planning to run update statistics to keep the statistics up...

thanks Jefferey,

Here I considered the page_count>1000. Is that right criteria to consider for finding Index fragmentation that are only having page count>1000?

thanks again

So if the index of type HEAP has fragmentation 99.35, then if I rebuild that heap,...

1st concern Do we really required to run the Index rebuild task on weekly, if the indexes are not getting fragmented (Here, I have noticed that only couple of indexes...

Hi,

I'm using maintenance plan for database Integrity check.Could you please tell me what the difference in performing Integrity check using T-sql code (dbcc checkdb (dbname) with no_infomsgs) & Maintenance plan...

Hi,

I went to through the below link which address the same issue

http://blogs.msdn.com/sqlserverfaq/archive/2009/08/20/unable-to-failover-a-named-instance-of-sql-server-2005-in-cluster-or-unable-to-bring-a-named-instance-of-sql-server-2005-online.aspx?CommentPosted=true#commentmessage

So after Uninstalling all the 4 SQL Server instances, I can still the below keys in registry...

Hi,

I have uninstalled all SQL Server 2005 instances, cliet tolls & SQL Server 2008 client tools again and rebooted the both the nodes and started the fresh SQL Server 2005...

thanks Brain,

I just tried installing SQL Server 2008 client tools only on Node1 and then the resource is came online!!

Now I do Not want SQL Server 2008 components at all...

Hi Brain,

I exactly got the same issue. In dev environment, we have 2 node Active/Active cluster setup with SQL Server 2005

On Node1: We have 2 SQL Server 2005 instances

VS1\Ins1

VS2\ins2

On Node...

please see the errors from the event viewer:

1st error:

Event Type:Error

Event Source:MSSQL$INS1

Event Category:(3)

Event ID:19019

Date:1/7/2010

Time:9:52:14 AM

User:N/A

Computer:ABC

Description:

[sqsrvres] ODBC sqldriverconnect failed

2nd error:

Event Type:Error

Event Source:MSSQL$INS1

Event Category:(3)

Event ID:19019

Date:1/7/2010

Time:9:52:14 AM

User:N/A

Computer:ABC

Description:

[sqsrvres] checkODBCConnectError: sqlstate = IM002; native error =...

Could you please advice me on viewing these standard reports from management studio? because when ever I open this reports, I'm getting Memory issues, seeing low virtual memory message in...

Thanks,

We performed the exact steps, discussed in this thread, in Production and everything worked well.

thanks for your help

Thank you. It's worked fine