SqlServer-QA.net

Another FAQ within newsgroups & forums that will SQL Server Clustering supports load balancing? It is quite common for a newbie to say and look at Clustering configuration such as Active-Active where you have n+1 nodes as a serving instances, the only difference between Active-Passive configuration is having 2(+n) active nodes at a ...

During a database design there has been an interesting discussion that will there be any performance addition in adding a second non-clustered index on a Globally Unique ID (GUID) column that has already a unique clustered index. IF needed you need to consider the usage of GUID column carefully, to accomodate the unique key across the database ...

Does rebuilding a clustered index rebuild nonclustered indexes? I have discussed this question with one of SQL Server MVP recently, eventually both were correct to the point. Lately I have found KhenBlog on the subject, interesting.