Browse by Tags

• execution
• performance
• plan
• security
• sql server
• ssms

Execution plans caching and how SQL optimizer reuses for better performance
25 April 07 01:16 PM | SQL Master | 1 Comments   

Memory plays important role in Performance on a windows based platform, SQL Server 2005 features has a pool of memory that is used to store both execution plans and data buffers, only the part of memory is used to store execution plans that we call as Read More...

Filed under: ssms, performance, sql server, management, query, plan

Estimated rowcount affects the performance - SQL 2005
25 April 07 01:02 PM | SQL Master | 1 Comments   

Using Query Analyzer you can get an estimated execution plan for a query against a database, in that plan the estimated number of rows is incredibly important when Query Analyzer is choosing an execution plan. In the real terms this is something to be Read More...

Filed under: performance, sql server, security, management, query, execution