All Articles - SQL Authority with Pinal Dave

SQL SERVER – PowerShell Script – When Was SQL Server Last Restarted?

May 13, 2015

I have always wanted to learn a bit of scripting and I was always searching for a good reason to learn something new. As I said, this is my learning and I am open to learning some scripting tricks from you too. So do let me know how the below…

SQL SERVER – Identify Page Splits Using Extended Events in SQL Server

May 12, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Extended Events

Digging some of my older posts reveal I have written a blog already on Page Splits with SQL Server. This was no surprise because I am in constant need to reinvent as I write the blog posts. Now you might ask, why was I searching. Well, when I was talking…

SQL SERVER – Introduction to Database Engine Tuning Advisor (a.k.a. DTA)

May 11, 2015

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

While talking to one of the attendees after my session at GIDS, I realized that I don’t have much information available on my blog about the usage of one of the fantastic performance tuning tool called Database Engine Tuning Advisor. This is also called as Database Tuning Advisor or DTA…

Interview Question of the Week #019 – How to Reset Identity of Table

May 10, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Scripts

Here is the question which I received in email: Question: I have a table which has an identity column. I have recently deleted old and archive it to another place. Now I want to reset the identity of the table to original value of 1. How should I do that? Answer:…

SQL SERVER – Script: Current IO Related Waits on SQL Server

May 9, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

Playing around with DMVs is so much fun. Many a times we need little inspiration and a problem in hand to solve. Out of many things I monitor, I have personally seen folks having trouble in finding what is going wrong when the server turns slow. In a recent conversation…

SQL SERVER – Backup Failure – Error: 3203, Severity: 16, State: 1

May 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Error Messages

In the recent past, I have been writing about different error messages on SQL Server that one encounters. Thanks to my blog readers who have been sharing a lot of errors with me either by email or by blog comments and asking for solution. If I find something interesting and…

SQL SERVER – Using Package Configurations in SSIS 2012 and Beyond – Notes from the Field #079

May 7, 2015

Pinal Dave

SQL

Notes from the Field, SQL Server, SSIS

[Notes from Pinal]: I know quite a lot of things about SSIS but every single time when I read notes from the field, I realize that there are so many small but very important features exist. A similar concept has been Using Package Configurations in SSIS 2012 and Beyond. Packages are the most critical part of the SSIS and configuring it correctly is extremely important.

SQL Server – Knowing the Use of Deprecated or Discontinued Features

May 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Deprecated Feature

Upgrading your SQL Server environment is inevitable and I know most many are doing this given SQL Server 2005 support will end first half next year. Whenever I get in front of customers, I have questions always coming my way around upgrades. In a recent session, I had one of…

SQL SERVER – Generating Row Number Without Ordering Any Columns

May 5, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server

Row_number function is used to generate a serial number for a given record set. But you need to always use ORDER BY clause so that the numbers are assigned to the specific order.

SQL SERVER – Who ALTER’ed My Database? Catch Them Via DDL Trigger

May 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is an interesting comment from one of my previous blogs on how to change the compatibility level of SQL server post posted earlier. Some of these comments are interesting and can provide some interesting extension to blog ideas like this. So the comment was: Under what circumstances would SQL…