Pls Check This ...

http://www.gogrid.com/

Thank You,

Best Regards,

SQLBuddy

Please post your memory configuration and SQL Server information , 32 bit 64 bit etc

...

Enable Optimize for Adhoc Workloads option for the SQL Server Instance. This will reduce the procedure cache bloating and the CPU compilation overhead.

sp_configure 'show advanced options', 1...

As Gail already mentioned, you need to use ALTER DATABASE Command.

Check if this helps..

http://adventuresinsql.com/2010/04/script-to-create-a-tempdb-file-per-processor/

Just comment out -- EXEC sp_executesql @alter_command

http://www.sqlskills.com/BLOGS/PAUL/category/Misconceptions.aspx#p22

Just make sure that the Autogrowth, maxsize...

SQL Server Native DR tools are pretty robust and reliable. However, 3rd party tools are dedicated tools just for the purpose of the DR, which may provide you with some...

Pls check the following

http://www.mssqltips.com/tip.asp?tip=1412

http://blogs.msdn.com/b/sqlserverfaq/archive/2008/06/02/how-to-change-the-dynamic-port-of-the-sql-server-named-instance-to-an-static-port-in-a-sql-server-2005-cluster.aspx

...

Pls check these links

http://www.sqlservercentral.com/articles/Installation/66128/

http://www.sqlservercentral.com/blogs/sql_performance/archive/2010/02/05/microsoft-sql-server-2005-service-pack-3-installation-in-cluster-environment.aspx

http://www.sqlcoffee.com/Tips0007.htm

Thank You,

Best Regards,

SQLBuddy

TRUNCATEONLY doesn't help much. As long as tempdb is in use, you can't shrink it no matter which method you follow. Try to kill the spids using Tempdb and then...

Check this

http://support.microsoft.com/kb/307487

Thank You,

Best Regards,

SQLBuddy

http://www.brentozar.com/best-sql-server-dba-books/

Thank...

It is not compatible with previous versions.

"The Performance Data Collector is fully supported by the Enterprise and Standard editions of SQL Server 2008. Out of the box, it only works...

As Francis mentioned, SSRS is not clustered aware. So the recommended aproach is to Install SSRS on a standalone server and put the SSRS dbs on the clustered instance.

I think...

I think you have done all the necessary things. Also try to run the update statistics.

Also you need to check for any code that is using the discontinued features like...

I think you can also create a VMWare ESX Server farm with those 2 blade servers (or add them to the existing farm) . Then create VMguests and setup...

Hi Dan,

Check this free tool from Idera.

http://www.idera.com/Products/Free-Tools/SQL-job-manager/

...