Browse by Tags

SQL Server 2005: Clustering FAQ is Active/Active a load balancing solution?

Published 29 February 8 4:4 AM | SSQA.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...

Filed under: sql server, performance, blogs, environment, clustered, clustering, san, best practice, monitoring, benchmarking

Performance consideration or overhead having primary key with 3 GUID (Clustered Index)

Published 25 September 7 4:17 PM | SSQA.net

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...

Filed under: sql server, performance, indexes, view, clustered, guid, uniquire, overhead

Does rebuilding a clustered index rebuild nonclustered indexes?

Published 25 June 7 3:45 PM | SSQA.net

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....( read more ) Read...

Filed under: sql server, performance, indexes, rebuild, clustered