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
Join Type

SQL SERVER – Change Join Type for Query

April 22, 2021
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

“Can I Change Join Type for Query?” I was recently asked this during  Comprehensive Database Performance Health Check. Of course Yes!

Read More
backup files

Multiple Backup Copies Stripped – SQL in Sixty Seconds #156

February 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL in Sixty Seconds, SQL Restore, SQL Server, SQL Server Management Studio, SSMS

Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.

Read More
backup files

SQL SERVER – Creating Multiple Backup Files – Stripped

February 18, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Server, SQL Server Management Studio, SSMS

One of my long-term clients (Comprehensive Database Performance Health Check) recently asked me question if I know a way of creating multiple backup files.

Read More
Hide in Code

Hide Code in SSMS – SQL in Sixty Seconds #154

February 3, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Management Studio, SQL Server Security, SQL Stored Procedure, SSMS

I have received so many emails from all of you to create a video on the topic of SQL SERVER – Hide Code in SSMS. Here is the video on the topic.

Read More
hide code

SQL SERVER – Hide Code in SSMS

February 2, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Encryption, SQL Server Management Studio, SQL Server Security, SQL Stored Procedure, SSMS

Today we are going to learn something very simple but asked a lot by all of you as well as my client is that how to hide code in SSMS.

Read More

Zoom in SSMS – SQL in Sixty Seconds #153

January 29, 2021
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server Management Studio, SSMS

It is possible to zoom in the SSMS (SQL Server Management Studio). I was recently asked by my client if this is even possible during Health Check.

Read More
find a table

Find a Table in Execution Plan – SQL in Sixty Seconds #151

January 27, 2021
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Server, SQL Server Management Studio, SSMS

While all other methods work fine, let us see how easily we can find this in an SSMS. Let us learn how to find a table in an execution plan.

Read More
Previous 1 2 3 4 5 … 48 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version