set showplan_all on go set noexec on go -- query to test select * from sysobjects -- end of query to test go set noexec off go set showplan_all off go
Tuesday, 23 April 2013
Get sql server execution plan
You can get the execution plan for queries in SQL server using the following script. This will display the execution plan and not run the script, so you wont need any data in the db in order to get the execution plan.
Heres a quick example to show how annotations can be used as join points in AOP. The code below simply times the execution of any method wit...
In many database driven applications it can be useful to automate the testing of SQL against a real database. However setting up and maintai...
This post outlines the usages of datalakes and data warehouses. Source: https://www.kdnuggets.com/2015/09/data-lake-vs-data-warehouse...