Welcome!

This page contains a set of tools, utilities, and queries shared by Switch Architecture with the community to assist other developers, architects, and administrators.

All of the source code is available on our GitHub community repository and distributed freely under the MIT license.

Do you have questions or feedback? Feel free to reach out to us at [email protected] or @wesatswitcharch.

SQL Server Tools

 
usp_Utility_DropTempTables
This utility is a stored procedure that will drop all #temporary tables that exist for the current session. More context on it’s purpose and usage may be found in the “Say goodbye to dropping temporary tables” article.

View the source code
Download the .SQL