Adding SELECT Excel hyperlinks to recordsets

Users frequently want spreadsheets with embedded links to web pages, one per row. This is one way to get them.

Views –…

Read More

Getting the plan handle for a sproc

You can use this T-SQL to get the plan handle for a sproc that has a bad execution plan:

Make sure, to…

Read More

Viewing the execution plan for a specific Sproc

Views – 1619

Read More