June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
replace STAR

SSMS Efficiency – Replace STAR – SQL in Sixty Seconds #130

October 7, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Server, SQL Server Management Studio, SSMS

You might have heard that SELECT * is bad for queries performance. Let us learn in today’s video how we can replace STAR (*) by column name.

Read More

Cycle Clipboard Ring – SQL in Sixty Seconds #129

October 6, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SQL Shortcut, SSMS

Copy (CTRL + C) and Paste (CTRL + V) are the friends of the DBAs and Developers. In SQL Server it is totally possible to use the Cycle Clipboard Ring.

Read More
statistics IO

SET STATISTICS IO ON – SQL in Sixty Seconds #128

October 5, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Statistics, SSMS

I am working with clients on helping them tune their SQL Server Performance. Let us learn how we can use SET STATISTICS IO to check the query’s performance.

Read More
pinned tab

Pinned Tab – SSMS Efficiency Tip – SQL in Sixty Seconds #121

September 9, 2020
Pinal Dave
SQL Tips and Tricks
SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SSMS

Lots of people asked me to share the SSMS efficiency tip so I have shared the same in this blog post. Today’s topic is the pinned tab in SSMS for efficiency.

Read More
split screen

Split Screen for SSMS Efficiency – SQL in Sixty Seconds #120

September 8, 2020
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SSMS

I often struggle to remember the changes done to the stored procedure and in this situation, the Split Screen of SSMS really comes very helping.

Read More
recent execution

Recent Execution of Stored Procedure – SQL in Sixty Seconds #118

September 5, 2020
Pinal Dave
SQL Video
SQL DMV, SQL in Sixty Seconds, SQL Server Management Studio, SQL Stored Procedure, SSMS

My clients were not sure which SPs are the recent SP and which SP is no longer used. Today we will learn about the recent execution of the stored procedure. 

Read More
full-screen

Full-Screen Execution Plan – SQL in Sixty Seconds #117

September 4, 2020
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Performance, SQL Server Management Studio, SSMS

There are two primary tools – 1) Execution Plan and 2) Statistics IO. In this blog post, we will see how we can get the full-screen execution plan. 

Read More
Previous 1 … 3 4 5 6 7 8 9 … 26 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version