May 2026 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
  • Hire Me
  • Health Check
May15

SQL SERVER – List All Memory Optimized Tables in TempDB

Pinal Dave
SQL Performance
Execution Plan, In-Memory OLTP, SQL Memory, SQL Scripts, SQL Server, SQL TempDB
No Comments

I received a very interesting question from my client. The question was about how to list all the Memory Optimized Tables in TempDB.

Read More
May14

SQL SERVER 2019 – Memory-Optimized TempDB and RESOURCE_SEMAPHORE Wait Type

Pinal Dave
SQL Performance
Execution Plan, In-Memory OLTP, SQL Memory, SQL Scripts, SQL Server, SQL TempDB
2 Comments

After looking at the execution plan, I realized it was actually built for a very simple query. Today let us discuss Memory-Optimized TempDB and Performance.

Read More
May13

SQL SERVER – Resources for DevAroundTheSun Session

Pinal Dave
SQLAuthority News
Presentation, SQL DateTime
No Comments

Dev Around The Sun is a technology event with tech talks and human skills talks. In this blog post, we will see important resources for DevAroundTheSun.

Read More
May12

SQL SERVER – Visible Offline Scheduler and Performance

Pinal Dave
SQL Performance
CPU Scheduler, CPU Threads, SQL CPU, SQL DMV
1 Comment

Not every problem is complex but all the problems are for sure interesting. Today we will discuss Visible Offline Scheduler and Performance. 

Read More
May11

SQL SERVER – Resolving Last Page Insert PAGELATCH_EX Contention Changing Primary Key to Non-Clustered

Pinal Dave
SQL Performance
oStress, Primary Key, SQL Constraint and Keys, SQL Identity, SQL Scripts, SQL Server, SQL Wait Stats, SSMS, Stress Testing
1 Comment

You can change your clustered primary key to Non-clustered Primary Key and can get the benefit of performance by reducing Pagelatch_EX.

Read More
May10

Where to Download SQL Server 2019 for FREE? – Interview Question of the Week #276

Pinal Dave
SQL Interview Questions and Answers
SQL Download, SQL Sample Database, SQL Server, SQL Server 2019, SQL Server Management Studio, SSMS
1 Comment

Question: Where to Download SQL Server 2019 for FREE?

Answer: This is one of the most popular questions, I keep on receiving from blog readers.

Read More
May9

SQL SERVER – Add Folder Paths to the Windows Path Variable for Easy Access

Pinal Dave
SQL Tips and Tricks
oStress, SQL Command, SQL Utility, Stress Testing, Windows
1 Comment

I was working with a DBA and he asked me question if thee any way to Add Folder Paths to the Windows Path Variable for Easy Access.

Read More
Previous 1 … 97 98 99 100 101 102 103 … 830 Next

SQL SERVER – Find Primary Key Using SQL Server Management Studio

SQL SERVER – Explanation about Usage of Unique Index and Unique Constraint

SQL SERVER - 2008 - Interview Questions and Answers - Part 1 5_AllQuery

SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint

SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name

SQLAuthority News – SharePoint – Steps To Create A Custom WebPart – Deploy It SharePoint Site

SQLAuthority News – 700 Articles and Author Updates

SQL SERVER – 2008 – Interview Questions and Answers – Part 1

Previous 1 … 97 98 99 100 101 102 103 … 830 Next

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

Pinal has authored 14 SQL Server database books and 104 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 an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@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.


Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.


SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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