I agree you all. But am imagining like restore a backup of msdb to another instance of same version and then upgrade to newer version, then restore to target msdb.???...

I do not think mirrored database can be taken offline. Depending on what maintenance work you will do, you need to reconfigure it later.

A Perfect Explanation. Thanks Gila.

I meant to say empty space inside pages. If pages have lots of empty space inside them, these unused spaces will affect exeution plan?

as per your reply, am going...

Can you please explain Internal Fragmentation also cant affect an exeuction plan?

when index being accessed first time, their statsitics with same name wiill be created automatically and listed under "Statistics".

http://blog.idera.com/sql-server/understanding-sql-server-statistics/

http://technet.microsoft.com/en-us/library/ms189315(v=sql.105).aspx

Yes, Perry means so.

http://ask.sqlservercentral.com/questions/4065/adding-a-datafile-to-a-log-shipping-primary.html

http://ramaudaya.blogspot.com/2011/09/adding-additional-datafile-to-primary.html

I am not sure. But could it be a virtual memory related error? Due to disk fragmentation, large memory area for page file can not be allocated!!!!!

I am not much comfortable with Sql Audit feature. I would suggest to use native auditing (Properties->Secutiry-> Both failed and Successful logins)

Is it system statistics?

I beleive it can be dropped by DROP STATISTICS [dbo].[tablename].[statsname] command.

Clients toos are same across all editions, but they may behave unexpectedly when connected to different version/editions

Full backup file is being overwritten(append) by Differential backup so file size increases.

You are right. A high unusual metric of check point pages /sec may indicate your database need more memory since free pages in memory is required at high rate. To...

First of all, I suggest a clean sql backup of your user database as well system database (Master, Msdb and model) prior to start of upgrade.

At the same time, SAN...