This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Dec2

SQL SERVER – XEvents to Find Cardinality Estimation Issues

Pinal Dave
SQL Tips and Tricks
SQL Extended Events
No Comments

Is there a way to find cardinality estimation issues? I use the query_optimizer_estimate_cardinality XEvent to see how each operator’s estimate is derived.

Continue Reading
Dec1

SQL Server – T-SQL Enhancement “Drop if Exists” clause

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server 2016
10 Comments

Tired of IF OBJECT_ID checks before every DROP? SQL Server 2016 adds a T-SQL enhancement I wanted for years, the DROP IF EXISTS clause. Here is how it works.

Continue Reading
Nov30

SQL SERVER – Practical Tips to Reduce SQL Server Database Table Size – Experts Opinion

Pinal Dave
SQL Tips and Tricks
Devart, SQL Table Operation
3 Comments

Practical tips to reduce SQL Server database table size, from my friend and SQL Server expert Sergey, for faster queries and smaller storage.

Continue Reading
Nov29

Interview Question of the Week #047 – Logic To Find Weekdays Between Two Dates

Pinal Dave
SQL Interview Questions and Answers
13 Comments

How do you find weekdays between two dates in SQL Server? Here is a simple user defined function that loops through the dates and skips Saturday and Sunday.

Continue Reading
Nov28

SQL SERVER 2016 – Comparing Execution Plans

Pinal Dave
SQL Performance
Execution Plan, MySQL
2 Comments

A query runs fine in test but slow in production? SQL Server 2016 tools add a way of comparing execution plans so you can find what changed.

Continue Reading
Nov27

SQL SERVER – Installing and Getting Started With Semantic Search

Pinal Dave
SQL Tips and Tricks
No Comments

To use semantic search you need Full-Text and Semantic Extractions for Search installed. Here is how to check the install and get started with semantic search.

Continue Reading
Nov26

SQL SERVER – Availability Group and the Six Critical Steps for DBAs to Follow – Notes from the Field #104

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Function
No Comments

Mike Lawell shares six critical steps every DBA should follow when asked to implement an AlwaysOn Availability Group. Notes from the Field #104.

Continue Reading
Previous 1 … 348 349 350 351 352 353 354 … 847 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 19 books and 125 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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