Feb 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
Feb22

SQL SERVER – Convert Date Time AT TIME ZONE

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

My client last week about Comprehensive Database Performance Health Check. The question was how to Convert Date Time AT TIME ZONE.

Read More
Feb19

Multiple Backup Copies Stripped – SQL in Sixty Seconds #156

Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL in Sixty Seconds, SQL Restore, SQL Server, SQL Server Management Studio, SSMS
No Comments

Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.

Read More
Feb18

SQL SERVER – Creating Multiple Backup Files – Stripped

Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Server, SQL Server Management Studio, SSMS
3 Comments

One of my long-term clients (Comprehensive Database Performance Health Check) recently asked me question if I know a way of creating multiple backup files.

Read More
Feb17

SQL SERVER – AlwaysOn and Propagation of Compatibility Level

Pinal Dave
SQL Tips and Tricks
AlwaysOn, Compatibility Level, Database Compatible Level, SQL High Availability, SQL Mirroring, SQL Server
1 Comment

It is not possible to Propagation of Compatibility Level in AlwaysOn or mirroring from primary to secondary mirroring. Let us learn it today.

Read More
Feb16

SQL SERVER – STRING_ESCAPE() for JSON – String Escape

Pinal Dave
SQL Tips and Tricks
Quotes, SQL Scripts, SQL Server
No Comments

Well, in situations like this we should consider using the function STRING_ESCAPE() which works for JSON. Let us quickly discuss String Escape.

Read More
Feb15

Forwarded Records and Performance – SQL in Sixty Seconds #155

Pinal Dave
SQL Tips and Tricks
Fragmentation, SQL Heap, SQL in Sixty Seconds, SQL Scripts, SQL Server
No Comments

Earlier I wrote a blog post on Forwarded Records and Performance and lots of people liked the blog post. Here is you can read the blog post SQL SERVER – What is Forwarded Records and How to Fix Them?

Read More
Feb12

SQL SERVER – List Tables with Size and Row Counts

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server
4 Comments

Today we will see a very simple script that lists table names with the size of the table and along with that row counts. Let us learn it in today.

Read More
Previous 1 … 60 61 62 63 64 65 66 … 829 Next
SQL SERVER - 2005 - Display Fragmentation Information of Data and Indexes of Database Table xsym

SQL SERVER – Quick Note on CROSS APPLY

SQL SERVER – Most Frequently Asked Generic Interview Questions

SQL SERVER – Download Frequently Asked Generic Interview Questions

SQL SERVER – 2005 – Introduction and Explanation to SYNONYM – Helpful T-SQL Feature for Developer

SQL SERVER - 2005 - Display Fragmentation Information of Data and Indexes of Database Table dbtoexcel

SQL SERVER – Export Data From SQL Server to Microsoft Excel Datasheet

SQL SERVER – Execute Same Query and Statement Multiple Times Using Command GO

SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table

Previous 1 … 60 61 62 63 64 65 66 … 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 100 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