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

ANSI PADDING and Storage – SQL in Sixty Seconds 210

January 16, 2025
Pinal Dave
SQL Video
SQL Data Storage, SQL Server Configuration

ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR and VARCHAR.

Read More
Instance Hiding

SQL SERVER – What is Instance Hiding? How to do it?

August 8, 2023
Pinal Dave
SQL Tips and Tricks
SQL Server Configuration, SQL Server Security

In this blog post, I’ll share a real-life success story of how instance hiding significantly strengthened SQL Server security for one of my clients.

Read More

SQL SERVER – Monitoring Database Autogrowth Settings

July 19, 2023
Pinal Dave
SQL Performance
autogrowth, SQL Server Configuration

Monitoring Database Autogrowth Settings is important and is what I often end up discussing in Comprehensive Database Performance Health Check;

Read More
password policy

SQL SERVER – Setting up a Robust Password Policy

July 17, 2023
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Server Configuration, SQL Server Security

Today’s topic of Setting up a Password Policy often emerges during my Comprehensive Database Performance Health Check consultations.

Read More

SQL Server 2022 – Degree of Parallelism (DOP) Feedback for Optimize Query Performance

June 26, 2023
Pinal Dave
SQL Performance
Compatibility Level, Database Scoped Configurations, MAXDOP, Parallel, Query Store, SQL CPU, SQL DMV, SQL Server 2022, SQL Server Configuration

SQL Server 2022 introduces a powerful new feature called Degree of Parallelism (DOP) feedback as part of the Intelligent Query Processing (IQP).

Read More
Optimize for Adhoc

Optimize for Ad Hoc Workloads – SQL in Sixty Seconds #173

June 10, 2021
Pinal Dave
SQL Video
Ad Hoc Query, Execution Plan, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Configuration

Today we are going to discuss if we should keep Optimize for Ad Hoc Workloads true or false. Let us see a detailed video about it.

Read More
adhoc queries

SQL SERVER – AdHoc Queries and Optimize for Adhoc Workloads

April 16, 2021
Pinal Dave
SQL Tips and Tricks
Ad Hoc Query, SQL CPU, SQL Scripts, SQL Server, SQL Server Configuration

Discussion with a client during the Comprehensive Database Performance Health Check.  The topic is AdHoc Queries and Optimize for Adhoc Workloads.

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

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

Go to mobile version