Browse by Tags

SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?

Published 18 March 8 4:20 AM | SSQA.net

First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration...

Filed under: sql server, performance, security, clustering, 2005, partition, monitoring, active/passive, parallel execution, performance monitoring, active/active, scalability

Considering Parallel plans and forcing plans for better performance

Published 23 October 7 8:55 AM | SSQA.net

Parameterizing T-SQL queries are a well-known task such as database programming and best practice in some tasks. It allows query plan reuse and eliminates the need of recompilation for multiple invocations of the same query that simply has different parameter...

Filed under: sql server, performance, optimization, cache, index, cpu, partition, guide, parallel execution, force