All Articles - SQL Authority with Pinal Dave

Interview Question of the Week #015 – How to Move TempDB to Different Drive

April 12, 2015

Here is one of the most popular questions I often come across- Question – How to move the TempDB to different drive when the log files are filled? Answer – In most of the cases which I have observed one has to move the TempDB to different drive when TempDB log…

SQL SERVER – CONCAT function and NULL values

April 11, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL String

CONCAT is the new T-SQL function introduced in SQL Server 2012. It is used to concatenate the values. It accepts many parameter values seperated by comma. All parameter values are concatenated to a single string. A simple example is SELECT CONCAT('SQL Server',' 2012') which results to SQL Server 2012 The…

SQL SERVER – Login Failed For User – Reason Server is in Script Upgrade Mode

April 10, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I just can’t get enough of the error messages that land into my Inbox almost every single day. I do my due diligence of making a search in my blogs and I try to hang around in the forums from time to time to learn what people are getting as…

SQL SERVER – The Basics of the File System Task – Part 2 – Notes from the Field #075

April 9, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SSIS

[Note from Pinal]: This is a new episode of Notes from the Field series. SQL Server Integration Service (SSIS) is one of the most key essential part of the entire Business Intelligence (BI) story. It is a platform for data integration and workflow applications. In this episode of the Notes from the…

SQL SERVER – Introduction to Policy Management

April 8, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Policy Management

As March comes, most of us are trying to chase our dreams and hope the much awaited yearend review comes good for us. I know many pray and don’t realize it is just an assessment of what was done the whole of last year. It is not a myopic view,…

SQL SERVER – What is Filtered Statistics?

April 7, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Statistics

Continuous learning is the only way to keep myself up-to-date with SQL Server product features. While I was working for a demo to show usage of SQL Server Statistics, I came across feature called Filter Statistics which was introduced in SQL Server 2008. There are many times when we have…

All Articles rebuildlog-simple-recovery-01-600x400

SQL SERVER – Transaction Log Backup Failing After Rebuilding Database Log File

April 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Speaking at community events get me really energized. It is wonderful to connect with people who build some of the greatest code ever for their respective organizations. Last weekend, I was at a conference in Delhi and it was an awesome opportunity for me to meet a number of you.…

Interview Question of the Week #014 – How to DELETE Duplicate Rows

April 5, 2015

Pinal Dave

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

Here is another very common question I often received, which candidates face in the interview. Question: How to delete duplicate rows in SQL Server (considering there is an identity column in table)? Answer: Well, there is no better answer than following a script. If you ask me this question in…

SQL SERVER – An Observation SET vs SELECT in T-SQL

April 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In SQL Server both SET and SELECT can be used to assign a value to a variable as shown in the following example DECLARE @no INT SET @no=10 SELECT @no AS no GO DECLARE @no INT SELECT @no=10 SELECT @no AS no GO The result is 10 You can also…

SQL SERVER – Log Shipping – Sharing Tab Missing in Folder Properties

April 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Log

Building a solution for some sort of disaster site is critical for every organization that thinks about business continuity. One of the proven for ages is a solution around Log Shipping. Though one of the oldest, it is one of the most sought after solution inside SQL Server. With solutions…