Finally !

Shared with you guys that the problem is turned out to be that the table has computed column using a user function , and the new released...

use database

go

select * from [schema].[tablename]

i use the above, the weirld part is that it works for all other tables except this one, even i try open it...

Thanks for reply guys, but it's NOT schema issue ( i am Sr. DBA i know that part), just wondering what could be wrong ?

tempdb will have heavy disk IO as the databases have snapshot isolation turned on .

All three LUNs are RAID 10, both data and log luns will have snap mirror...

Thanks Jason, appreciated , this helps !

High-Level POA...

1. install new instance of Analysis Services (AS) on the new server

2. ensure service account has appropriate access to the database instance on old server (for processing)

3. update old...

Thanks guys. So, those indexes will be created across both data files.

What about constraints ? Where are they stored ?

Not able to check hot standby 'cause it's in unrecovery mood, but thanks for the info, looks like we don't have choice but shutdown the application server and...

Thanks everyone. So, seems the answer is backup/restore will get rid of data/log files fragmentation ( i don't have to drag disks first on old box and do...

thanks Steve, is there any benefit for performance to put distribution database on seperate instance instead of production instance ?

You don't have to failover the instance , just apply it to passive node. Actually, you should apply it to passive node first, then failover the...

Thanks Jason, but I am still puzzling over something here, if you right , it's 8, then i can set : max degree of parallelism...

From BOL:

"The maximum value for thedegree of parallelism setting is controlled by the edition of SQL Server, CPU type, and operating system. If a value greater than the number...

Yes, that's the first thing i need to do before setup db mail.

Like i said, i did this db mail many many times without any issues including on 32bit...

Thanks ALZDBA , I go through the thread and double checked all SQL Browser services are running on both cluster nodes, the problem really seems like...