All Articles - SQL Authority with Pinal Dave

SQL SERVER – Dynamic SQL and Temporary Tables

July 22, 2019

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.

SQL SERVER – Swap Column Values In Table

July 16, 2019

Pinal Dave

SQL Tips and Tricks

SQL Column, SQL Scripts, SQL Server

Here is a question asked to me during Comprehensive Database Performance Health Check. The question was about how to swap column values in a table.

SQL SERVER – Microsoft Official Support End Dates for Different Versions

July 15, 2019

Pinal Dave

SQL Tips and Tricks

SQL Documentation, SQL Server

Earlier this week, Microsoft SQL Server 2008 and 2008 R2 support ended. I am mentioning Microsoft’s Official Support End Dates for different versions.