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
vertical text

SQL SERVER Management Studio – ALT + SHIFT Keys Trick to Select Vertical Text

October 11, 2019
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio, SQL Shortcut, SSMS

Nicklas Bågvinge sent me a very interesting SSMS tip. Let us learn how we can select vertical text in SSMS using ALT + SHIFT keys.

Read More
Removing Completion

SQL SERVER Management Studio – Removing Completion Time in Messages

October 10, 2019
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SSMS

I have received many curious emails and questions while working with clients on Removing Completion Time in Messages. Let us learn them today.

Read More
Become Idle

SQL SERVER – SQL Agent – Job Start Whenever the CPUs Become Idle

September 28, 2019
Pinal Dave
SQL Tips and Tricks
SQL CPU, SQL Server, SQL Server Agent, SQL Server Management Studio, SSMS

Recently I was asked by the customer of Comprehensive Database Performance Health Check about SQL Agent and Job starting whenever CPU Become Idle.

Read More
update ssms

SQL SERVER – Check for Update in SSMS

September 18, 2019
Pinal Dave
SQL Tips and Tricks
Cumulative Update, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

DBAs and Devs had many interesting questions during the Comprehensive Database Performance Health Check. How to check the update in SSMS?

Read More
dark theme

SQL SERVER Management Studio 18 – Enable Dark Theme

September 12, 2019
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio, SSMS

We are all techies and we love to use a dark theme in our IDEs. I get quite often a question about how to enable dark theme in SQL Server Management Studio.

Read More
completion time

SQL SERVER Management Studio – Completion Time in Messages

September 10, 2019
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

When the queries end, we know how long the query ran from the duration of the query but we never know their completion time. 

Read More
slow query

SQL SERVER – 5 Important Steps When Query Runs Slow Occasionally

September 7, 2019
Pinal Dave
SQL Performance
Maintenance Plan, SQL FileGroup, SQL Scripts, SQL Server, SQL Server Configuration, SQL Stored Procedure, SQL TempDB, SQL Wait Stats, SSMS

This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.

Read More
Previous 1 … 11 12 13 14 15 16 17 … 26 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version