May 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

SSMS and Execution Timeout – SQL in Sixty Seconds 209

January 13, 2025
Pinal Dave
SQL Video
SQL DateTime, SQL Server Management Studio, SSMS

Execution timeout in SSMS are a small but important feature that can help you manage query performance. Let us watch the video together.

Read More
max server memory

Why ‘Max Server Memory’ Isn’t Always the Limit

August 20, 2024
Pinal Dave
SQL Performance
DBA, SQL Memory, SSMS

What if I told you that setting a limit with “max server memory (MB)” doesn’t always mean SQL Server will stick to that limit?

Read More
maxservermemory

SQL SERVER – Understanding Maximum Server Memory

November 2, 2023
Pinal Dave
SQL Performance
SQL Memory, SQL Server Management Studio, SSMS

When optimizing your SQL Server for superior performance, understanding and correctly implementing the ‘maximum server memory’ setting is crucial.

Read More

SQL SERVER – Performance: OR vs IN

September 11, 2023
Pinal Dave
SQL Performance
Execution Plan, SQL Server Management Studio, SQL Statistics, SSMS

I recently asked on Twitter an exciting question about OR vs IN. While I got lots of good answers, there were an equal amount of wrong answers.

Read More
linenumber

SQL Server: How to Display Row Numbers in Query Editor for Efficient Query Editing

February 2, 2023
Pinal Dave
SQL Tips and Tricks
SQL Server, SQL Server Management Studio, SSMS

Let us learn how to Display Row Numbers in Query Editor for Efficient Query Editing. Comprehensive Database Performance Health Check

Read More

Remove Key Lookup – SQL in Sixty Seconds #194

February 21, 2022
Pinal Dave
SQL Video
Execution Plan, SQL in Sixty Seconds, SQL Index, SQL Performance, SSMS

Today, we are going to see one more trick from the book – Remove Key Lookup and improve the performance of queries.

Read More
Restoring State

SQL SERVER – Source Database in Restoring State

October 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

A client whom I often help with Health Check recently reached out to me with an interesting problem about Source Database in Restoring State.

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

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

Go to mobile version