Browse by Tags

• 2005
• active/active
• active/passive
• cache
• clustering
• cpu
• force
• guide
• index
• monitoring
• optimization
• partition
• performance
• performance monitoring
• scalability
• security
• sql server

SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?
18 March 08 02:20 AM | SQL Master | 3 Comments   

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

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

Considering Parallel plans and forcing plans for better performance
23 October 07 06:55 AM | SQL Master | 2 Comments   

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

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