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

SQL SERVER – Introduction to Policy Management

April 8, 2015

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…

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…

SQL SERVER – Quiz on knowing DATEPART and DATENAME Behaviors

April 1, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

Playing around with date and time datatypes can be loads of fun. I hope you got the pun intended when I say it is fun. Most of the developers working with date and time datatypes feel it is a pain. I understand their sentiments, but would like to let you…