Mar 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
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
May17

How to Know Backup Speed in SQL Server? – Interview Question of the Week #277

Pinal Dave
SQL Interview Questions and Answers
SQL Backup, SQL Restore, SQL Scripts, SQL Server
No Comments

Question: How to Know Backup Speed in SQL Server?

Answer: It is very simple to know the backup speed in SQL Server. Let us discuss today.

Read More
May16

SQL SERVER – List Database Available for Current User – HAS_DBACCESS

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL Server Security
No Comments

In those scenarios, we end up on a very elaborated training session. Let us learn today about how to List Database Available for Current User.

Read More
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
Previous 1 … 96 97 98 99 100 101 102 … 829 Next

SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example

SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search 1_Index

SQL SERVER – Introduction to Filtered Index – Improve performance with Filtered Index

SQL SERVER – 2008 – Hardware and Software Requirements for Installing SQL Server 2008

SQLAuthority Author Visit – Microsoft Student Partner Conference

SQLAuthirty Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 2008

SQLAuthority News – Download SQL Server Related Products

SQL SERVER - 2008 - Creating Full Text Catalog and Full Text Search 1_Catalog

SQL SERVER – 2008 – Creating Full Text Catalog and Full Text Search

Previous 1 … 96 97 98 99 100 101 102 … 829 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