Little Drops of Ink make Millions to Think! Introduction In this blog post, we are going to see a little trick that saves our valuable time in SSMS. Actually, if we need to change , include , remove or select a pattern in our SQL code or SQL scripts, most of us follow some of… Continue reading Little Trick to Save Time in SSMS
Category: Keyboard Shortcuts
ON and OFF IntelliSense within Session in SSMS
Introduction In this blog post, we will see how to Switch ON or OFF IntelliSense within Session Level in SSMS (SQL Server Management Studio). Refresh, Enable and Disable IntelliSense Feature in SSMS (SQL Server Management Studio) works commonly for all sessions. But here, we will see how to Enable or Disable IntelliSense within Session level in… Continue reading ON and OFF IntelliSense within Session in SSMS
Check Database Size in SQL Server for both Azure and On-Premises
Introduction In this blog post, we will see how to check the database size in SQL Server irrespective of Azure and On-Premises using common T-SQL. Here, we will see two easy methods that is Common for both On-Premises and Azure SQL DB. To Check Current Database Size Method 1 - Using 'sys.database_files' System View We… Continue reading Check Database Size in SQL Server for both Azure and On-Premises
Refresh, Enable, Disable IntelliSense Feature in SSMS (SQL Server Management Studio)
Introduction Microsoft IntelliSense is one of the feature that is available in the text editor of SSMS (SQL Server Management Studio).It would reduce our Typings and provide us quick access to syntax info. In this blogpost, we are going to know how to Refresh IntelliSense when it shows 'Error with red line' , and Enable… Continue reading Refresh, Enable, Disable IntelliSense Feature in SSMS (SQL Server Management Studio)
Keyboard Shortcut for Changing Databases/Database Selection in SSMS for both AZURE vs On Premise/Local Server
Keyboard Shortcut for Changing Databases/Database Selection in SSMS for both AZURE vs On Premise/Local Server