June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – CTRL+SHIFT+] Shortcut to Select Code Between Two Parenthesis

Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SQL Shortcut

Every weekend brings creative ideas and accidents brings best unknown secrets in front of us. Just a day while working with complex SQL Server code in SSMS I came across very interesting shortcut which I have never used before and instantly fell in love with it. It is totally possible that you are familiar with this but for me it was the first time and I was surprised that I did know know this short cut so far.

Read More

SQL SERVER – Tricks to Comment T-SQL in SSMS – SQL in Sixty Seconds #019 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
Code commeting is the one of the most common tasks developers perform. There are two major reasons why developer comment code. 1) During Debug 2) Documenting the code. While debugging the T-SQL code I have often seen developers struggling to comment code.  They spend (or waste) more time in commenting…
Read More

SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
Importing data into database is one of the most important tasks. I often receive questions regarding what is the quickest way to insert CSV data or how to import CSV Data into SQL Server Table. Honestly the process is very simple and the script is even simpler. In today’s SQL…
Read More