Starting with SQL Server 2014 a new troubleshooting capability is to monitors real time query progress with the DMV sys.dm_exec_query_profiles which is the base for Live Query Statistics new functionality for SQL Server 2016, there are two ways to enable real time query monitoring: Session scope: By enabling SET STATISTICS XML ON; or SET STATISTICS PROFILE ON;... » read more
Execution Plan in SSMS Run Stored Procedure in SSMS with “Execution Plan” enabled. SSMS will recommend index to be created. Improve Query Statement Convert subqueries to main queries. Note: This may not always increase performance. Have to run the both queries side by side to test.
Model Browser My default, the Model Browser panel does not show up in Endity Model editor. To show the Model Browser panel… Open up .edmx file. Right click and select “Model Browser”.
Error: For some reason, when I launch this application in the debugger using the normal Start Debugging command in Visual Studio, it launches, but it also produces the following warning: Resolution: Disable this option under Debug->Options->Suppress JIT optimization on module load (Managed only). Sources: https://stackoverflow.com/questions/38601643/error-you-are-debugging-a-release-build-of-x-dll
https://www.time.gov/
Error in Visual Studio: The type or namespace name ‘Dymo’ could not be found (are you missing a using directive or an assembly reference?) Fix: Interop.Dymo.dll
https://www.atlassian.com/git/tutorials/comparing-workflows/gitflow-workflow
Note: Make sure the user you are about to delete does not own anything in the database, else you will get an error message saying unable to delete user. Make sure the user does not own any of the SQL jobs.