Reading and understanding an execution plan graphical presentation

Problem: Reading and understanding an execution plan graphical presentation Solution: An execution plan is generally a logical algorithm of query processor chooses to execute the query. Execution plan is portrayed graphical from...

Read More

What is an execution and how to get execution plan of a query?

Problem: What is an execution and how to get execution plan of a query? Solution: Query is generally a block of declarative code executed against a database. When the execution happens SQL Server processes the query by the database engine....

Read More

What are different ways to get total number of rows in a table.?

Problem: What are different ways to get total number of rows in a table.? Solution: A Table stores data in the format of columns and rows. Every Table stores the total number of rows in different aspect. There are few different ways...

Read More

How to enable, disable or drop all or specific plan guides?

Problem: How to enable, disable or drop all or specific plan guides? Solution: sp_control_plan_guide This procedure controls or allows us to do few things ·         Drop one or all plan guides. ·         Disable...

Read More

What are plan guides and how to use a custom plan guide?

Problem: What are plan guides and how to use a custom plan guide? Solution: sp_create_plan_guide Plan Guides: For every query, there will be an execution plan which is actual and estimated by the SQL Server Optimizer. Plan guides lets...

Read More