All Articles - SQL Authority with Pinal Dave

SQL Server Performance Tuning Practical Workshop – Discovery Phase – Online Training

July 2, 2019

In this blog post, we will discuss Discovery Phase which I spent before I built successful SQL Server Performance Tuning Practical Workshop.

SQL Server Performance Tuning Practical Workshop – Discovery Phase – In Person Training

July 1, 2019

Pinal Dave

SQL Performance

SQL Server, SQL Training

In this blog post, we will discuss Discovery Phase which I spent before I built successful SQL Server Performance Tuning Practical Workshop.

All Articles Performance-Sum-Count-600x283

What is Faster, SUM or COUNT? – Interview Question of the Week #231

June 30, 2019

Pinal Dave

SQL Interview Questions and Answers

SQL Function, SQL Performance, SQL Scripts, SQL Server

Question: What is Faster, SUM or COUNT? Answer: Both are the same. I was asked this question during my Comprehensive Database Performance Health Check.

SQL SERVER – Automatic Seeding of Availability Database ‘SQLAGDB’ in Availability Group ‘AG’ Failed With a Transient Error. The Operation Will be Retried

June 29, 2019

Pinal Dave

SQL

AlwaysOn, SQL High Availability, SQL Scripts, SQL Server

Earlier I have written few blogs about automatic seeding feature. In this blog we would learn how to fix error: Automatic seeding of availability database.

SQL SERVER – Add Database to Availability Group Failure – This BACKUP or RESTORE Command is Not Supported on a Database Mirror or Secondary Replica

June 28, 2019

Pinal Dave

SQL

AlwaysOn, SQL Backup, SQL Error Messages, SQL High Availability, SQL Restore, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

In this blog post, we will fix the error related to This BACKUP or RESTORE command is not supported on a database mirror or secondary replica.

SQL SERVER – Different Size of COPY_ONLY Full Backup on Primary and Secondary Replica in Always On

June 27, 2019

Pinal Dave

SQL Tips and Tricks

AlwaysOn, SQL Backup, SQL High Availability, SQL Scripts, SQL Server

We will learn how the full backup size can be different on the primary and secondary replica for an availability database in Always On availability group.

SQL SERVER – SUSPENDED Sessions Waiting on PAGELATCH_UP and PAGELATCH_SH – Solution

June 26, 2019

Pinal Dave

SQL Performance

SQL FileGroup, SQL Memory, SQL Server, SQL TempDB, SQL Wait Stats

Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.

All Articles DBCC-FLUSHAUTHCACHE-600x277

SQL SERVER – Getting Started with DBCC FLUSHAUTHCACHE on SQL Azure

June 25, 2019

Pinal Dave

SQL Tips and Tricks

SQL Azure, , SQL Scripts, SQL Server, SQL Server Security

First thing first – the command DBCC FLUSHAUTHCACHE only is supported on SQL Azure. The behavior of change of password is a bit different on SQL Azure.