SQL Server Archives - Page 29 of 393 - SQL Authority with Pinal Dave

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

May 12, 2015

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 – 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.