Marc Your explanation stands highest in terms of HA & DR in terms of scalability too. Indeed agree on that point about achieveing HA and desiging the near-to-achieve architecture. As you refer data-tier is small part, but what I believe is this is imp...

Chandra When I said scalable then Peer-to-peer replication comes into picture, not Clustering or Mirroring. SO your response stands right in such reference, however your response covers larger picture not classified specific to scalability. Hope this h...

Thanks for the participation, indeed the explanation was top of the mark here.. keep going. Marc Indeed you had an important question raised, but they were incomplete without any pros and cons. The whole point of this Q is to identify what is the be...

Your task is design the high availability architecture that should comprise the above 3 features of SQL Server 2008 R2. Further the solution must comprise no downtime to the application having the explanation for each step you w...

Thanks for replies, appreciate your interest....

Discuss ETL and BI solutions and strategies (infrastructure and methods) to a retail provider using SQL Server 2008 R2 technologies....

Fellow peers and pros, FIrst of all apologies for confusion in the Q, due to a paragraph missout. I have been out of reach to modify/nsert the changes....

Your task is to generate a single TSQL statement to fetch the difference between the SYSTNODE value without having the need to use EXCEL....

A server side trace using TSQL tuning template produces that 3 stored procedures are used during those reports execution, a SHOWPLAN event activity reveals that there are multiple scan operations such as index scan, hash-join, i...