SSMS SHORTCUTS
Query Navigation and Editing: F5/Ctrl + E: Execute the current query. Ctrl + L: Clear the results pane. Ctrl + F5: Execute the current query and keep the results pane hidden. Alt + Break: Cancel a running query. Ctrl +…
Category SSMS
HOW TO CHECK FOR MSSQL FRAGMENTATION
Index fragmentation is when the data in an index is not stored in a continuous order. This can happen when data is added, deleted, or changed in a table. If an index is fragmented, it can take longer for SQL…
CREATING A SQL USER IN MSSQL WITH ACCESS TO A SINGLE STORED PROCEDURE USING THE GUI
In this blog post, we will guide you through the process of creating a SQL user in Microsoft SQL Server using the graphical user interface (GUI) provided by SQL Server Management Studio (SSMS). The user will have access to only…