SQL Extended Events Archives - SQL Authority with Pinal Dave

Capture Query Plans Using Extended Events and Traces – Analyzing SQL Server Query Plans – Part 1

November 4, 2019

Execution Plan, Pluralsight, SQL Extended Events, SQL Profiler, SQL Server, SQL Trace

I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss Capture Query Plans Using Extended Events and Traces.

SQL SERVER – xp_create_subdir() Returned Error 183, ‘Cannot Create a File When that File Already Exists

December 11, 2018

Pinal Dave

SQL

SQL Error Messages, SQL Extended Events, SQL Scripts, SQL Server

New client, new idea and a new blog! That’s how I have been writing a daily blog for many years now. In this blog, I would share my learning from a client who faced error “xp_create_subdir() returned error 183, ‘Cannot create a file when that file already exists” while running maintenance plan.

SQL SERVER – Timeout Occurred While Waiting for Latch: Class FGCB_ADD_REMOVE

October 11, 2018

Pinal Dave

SQL

Disk, File format, SQL DMV, SQL Error Messages, SQL Extended Events, SQL Log, SQL Server, SQL Server Configuration

One of my clients contacted me to resolve an issue where they were seeing these errors few minutes after restarting SQL Server Service. In this blog, we would learn about how to fix error Timeout occurred while waiting for latch: class FGCB_ADD_REMOVE.

SQL SERVER – Identifying Deprecated SQL Server Features with Extended Events

April 7, 2018

Pinal Dave

SQL Tips and Tricks

SQL Deprecated Feature, SQL Extended Events, SQL Scripts, SQL Server, SQL Server 2017

In this blog post with the help of Extended Events, we will learn how to identify all the deprecated SQL Server Features. This feature can be very much handy when we are changing the compatibility of SQL Server and we want to check what are all the deprecated SQL Server features we are still using in our active code.

How to Find SQL Server Deprecated Features Used by the Application? – Interview Question of the Week #165

March 18, 2018

Pinal Dave

SQL Interview Questions and Answers

SQL Deprecated Feature, SQL Extended Events, SQL Scripts, SQL Server

There are many applications which are developed using an older version of SQL Server. As there are new releases happening, there are features, command, and syntax which are marked as deprecated features and might get removed in future version of SQL Server. It is always challenging for the developer to remember what is changed in the new release of SQL Server and what changes they needed to make sure that their application works with the latest version of SQL Server.