All Articles - SQL Authority with Pinal Dave

SQL SERVER 2019 – How to Turn On or Enable Instant File Initialization?

January 6, 2020

Instant File Initialization, SQL Server, SQL Server 2019, SQL Server Configuration

In this blog, we would see the current setting of instant file initialization and how to make the modification. Let us learn about it today.

How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258

January 5, 2020

Pinal Dave

SQL Interview Questions and Answers

Computer Network, SQL Command, SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Map Network Drive as Fixed Drive in SQL Server?
love little problems like this one as they are indeed a lot of fun to resolve.

SQLBits 2020 – SQL Server Performance Tuning Real-World Scenarios – at ExCel London

January 4, 2020

Pinal Dave

SQLAuthority News

SQLBits

I will be presenting a day-long training at SQLBits on 31 March 2020 at ExCel London on the topic SQL Server Performance Tuning Real-World Scenarios.

SQL SERVER – SQL Azure Managed Instance Restore Error – The Database Was Backed Up on a Server Running Version 15.00.2000

January 3, 2020

Pinal Dave

SQL

SQL Azure, SQL Azure Managed Instance, SQL Error Messages, SQL Restore, SQL Server

One of my clients migrated to SQL Azure Managed Instance and contacted me for an interesting situation. Let us resolve Restore Error.

SQL SERVER – ISNUMERIC Function and Interesting Result

January 2, 2020

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL String

Let us learn, ISNUMERIC Function and Interesting Result. An interesting observation from my client of the Comprehensive Database Performance Health Check.

SQL SERVER – Performance and Recompiling Query – Summary

January 1, 2020

Pinal Dave

SQL Performance

Parameter Sniffing, Query Hint, SQL Scripts, SQL Server, SQL Stored Procedure

I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.

SQL SERVER – Parameter Sniffing and OPTION (RECOMPILE)

December 31, 2019

Pinal Dave

SQL Tips and Tricks

Parameter Sniffing, Query Hint, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Stored Procedure, SSMS

I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.

All Articles scopedconfiguration0-600x197

SQL SERVER – DATABASE SCOPED CONFIGURATION – PARAMETER SNIFFING

December 30, 2019

Pinal Dave

SQL Performance

Database Scoped Configurations, Parameter Sniffing, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Stored Procedure, SSMS

My client had hired me after reading my recent series on Parameter Sniffing. Today, we will discuss Database Scoped Configuration – Parameter Sniffing.