May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 3 Online SQL Courses at Pluralsight and Free Learning Resources

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQL Video
SQL in Sixty Seconds, SQL Training
Usain Bolt is an inspiration for all. He broke his own record multiple times because he wanted to do better! Read more about him on wikipedia. He is great and indeed fastest man on the planet. Usain Bolt – World’s Fastest Man “Can you teach me SQL Server Performance Tuning?”…
Read More

SQL SERVER – Identify Most Resource Intensive Queries – SQL in Sixty Seconds #028 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
During performance tuning conversation the very first question people often ask is what are the queries offending the server or in another word let us identify the queries which are the most resource intensive. The resources are often described as either Memory, CPU or IO. When we talk about the…
Read More

SQL SERVER – Copy Column Headers from Resultset – SQL in Sixty Seconds #027 – Video

Pinal Dave
SQL Video
Database, Excel, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

SQL Server Management Studio returns results in Grid View, Text View and to the file. When we copy results from the Grid View to Excel there is a common complaint that the column header displayed in resultset is not copied to the Excel. I often spend time in performance tuning databases and I run many DMV’s in SSMS to get a quick view of the server. In my case it is almost certain that I need all the time copy column headers when I copy my data to excel or any other place.

Read More

SQL SERVER – Effect of Collation on Resultset – SQL in Sixty Seconds #026 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
Collation is a very important concept but often ignored. I have often seen developers either not understanding this or ignored it – this is plain wrong. In simple word we can say Collation is the language or interpreting done by SQL Server. Well, in today’s SQL in Sixty Seconds we…
Read More

SQL SERVER – Three Methods to Insert Multiple Rows into Single Table – SQL in Sixty Seconds #024 – Video

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio
One of the biggest ask I have always received from developers is that if there is any way to insert multiple rows into a single table in a single statement. Currently when developers have to insert any value into the table they have to write multiple insert statements. First of…
Read More