All Articles - SQL Authority with Pinal Dave

SQL SERVER – Number of Rows Read Per Threads in Parallel Operations

July 26, 2019

Execution Plan, Parallel, SQL CPU, SQL DMV, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.

SQL SERVER – Query Specific Wait Statistics and Performance Tuning

July 25, 2019

Pinal Dave

SQL Performance

Resource Governor, SQL Memory, SQL Server, SQL Server Management Studio, SQL Wait Stats, SSMS

After a quick research we figured out the issue was with memory requirement for their query and we used to query specific wait statistics.

SQL SERVER – Performance Impact of Unique Index

July 24, 2019

Pinal Dave

SQL Performance

SQL Index, SQL Scripts, SQL Server, SSMS

In the latest Comprehensive Database Performance Health Check engagement, we had a very interesting situation of Performance Impact of Unique Index.

SQL Authority News – SysAdminDay – System Administrator Appreciation Day

July 23, 2019

Pinal Dave

SQLAuthority News

DBA, SQL Milestone

System Administrator Appreciation Day or SysAdminDay is celebrated on the last Friday in July. History says the celebration started in the year 2000.

SQL SERVER – Dynamic SQL and Temporary Tables

July 22, 2019

Pinal Dave

SQL Tips and Tricks

Dynamic SQL, SQL Scripts, SQL Server, SQL TempDB, SSMS, Temp Table

Earlier on this blog I received following follow up question about Dynamic SQL and Temporary Tables. Let us understand a bit more in detail.

Can an Index Reduce Performance of SELECT Query? – Interview Question of the Week #234

July 21, 2019

Pinal Dave

SQL Interview Questions and Answers

Question: Can an Index Reduce Performance of SELECT Query? There is a huge misconception that Indexes does not impact SELECT queries negatively.

All Articles Global-Temporary-Tables-600x302

SQL SERVER – Dynamic SQL and Global Temporary Tables

July 20, 2019

Pinal Dave

SQL Tips and Tricks

Dynamic SQL, SQL Scripts, SQL Server, SQL TempDB, SSMS, Temp Table

During the recent work of Comprehensive Database Performance Health Check, we had a very interesting situation of Dynamic SQL and Global Temporary Tables.

SQL SERVER – Upgrade Error: The Server Principal is Not Able to Access the Database “msdb” Under the Current Security Context

July 19, 2019

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security, SQL Upgrade, System Database

The Upgrade Error messages shown in ERRORLOG was “The server principal “SQLAuthority\AuthOwner” is not able to access the database “msdb”

SQL SERVER – SQL Agent Job and Backslash – Strange Behavior

July 18, 2019

Pinal Dave

SQL Puzzle

SQL Jobs, SQL Scripts, SQL Server, SQL Server Agent, SQL Stored Procedure

Today’s blog post is about SQL Agent Job and Backslash. I was surprised to see this behavior. Here are the steps to reproduce this behavior.

SQL SERVER – Enable or Disable Resource Governor

July 17, 2019

Pinal Dave

SQL Tips and Tricks

Resource Governor, SQL Memory, SQL Scripts, SQL Server

Resource governor which was accidentally enabled by one of their database administrators. Let us learn how to disable resource governor in this blog post.