SQL Tips and Tricks Archives - Page 132 of 536 - SQL Authority with Pinal Dave

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

May 10, 2015

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

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.

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…

Interview Question of the Week #018 – Script to Remove Special Characters – Script to Parse Alpha Numerics

May 3, 2015

Pinal Dave

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

SQL Function, SQL Scripts

If you ask me – there are certain questions not appropriate for an interview as they are often very subjective. There are some questions, which really do not help to identify if the candidate has the necessary skills or not. Here is one such question, if you ask me in the…