Alternatives · Basic Logics · Did you Know! · Keyboard Shortcuts · Play in SQL · Real Scenario Logic's

Little Trick to Save Time in SSMS

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

Advertisement
Basic Logics · Keyboard Shortcuts · Real Scenario Logic's

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

Alternatives · Basic Logics · Keyboard Shortcuts · Real Scenario Logic's

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

Basic Logics · Keyboard Shortcuts · Real Scenario Logic's

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)