Thank you all for participating :)...

Query which was working fine all the time suddenly got slow. List three most important priorities to resolve this issue....

Thank you all for participating :)...

Very interesting suggestions so far but this subject needs more explanation....

List three things to diagnose cube performance and tune it....

Create parallel execution plan and join operator using single table only once in single statement....

In SQL Server 2005 a single table can have maximum 249 non clustered index and 1 clustered index. In SQL Server 2008 a single table can have maximum 999 non clustered index and 1 clustered index. It is widely believed that a t...