I'm able to generate the...

In above script why we...

I just got the answer from the below link:-)

http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/6a5fce87-e9fa-4b45-b9f1-0905b64f7753/

thanks

Thanks,

which one is recommended for Production instance?

because I believe sp_MSforeachDB is an undocumented procedure.

Thank you,

I went through the link http://www.sqlskills.com/blogs/paul/category/CHECKDB-From-Every-Angle.aspx

and it says DBCC CHECKDB won't cause blocking.

But, In my case blocking happening only when DBCC CHECKDB runs.

So how can we rule out that...

It worked.

So we need to have separate folder for each database:-D:-D

I'm doing the Filestream RBS configuration for the second database similarly as I did for first database

Use WSS_Content_DB2

go

if not exists (select groupname from sysfilegroups where groupname=N'RBSFilestreamProvider')

Alter database WSS_Content_DB1

add filegroup RBSFilestreamProvider...

if there are 500 .trn files to apply to the database, then we have only have the option to restore manually one by one?

OS is Windows Server 2008 R2.

I went to My computer->Manage

But did not find...

Thanks for your immediate response

In SQLAgent, all jobs were disabled

Could you please tell me what is the exact sql statements that are involved in dead lock (in both dead locks).

Multiple processes involved here

The first one is doing an index rebuild. No idea why an index rebuild would be in the middle of an important process, but it's running. It...

how big is the page file? If its 10GB and 25% used then i'd say you need more RAM. You want as much going through RAM and as little written...

Could you please advice on this topic?

Could you please advice me?

Thanks

Could you please shed some light on this?

Thanks