SQL Archives - Page 130 of 519 - SQL Authority with Pinal Dave

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

April 5, 2015

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…

SQL SERVER – Script to find SQL Startup Account using WMIC

March 31, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Friends are your lifeline that keep your life interesting. I have various friends’ circles that range from family, acquaintances, work and the most exciting circle is the technical circles. Most of the times the tech circles is what fuels most of the post that lands up here. I was talking…

SQL SERVER – Using MaxTransferSize parameter with SQL Server Backups

March 30, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts, SQL Server

Off late I have been writing a lot around SQL Server backups and administration topics. I have seen a lot of my readers have been enjoying some of the deep conversations I have with people in the industry. As I always say, most of the blog posts are inspired by someone asking me a question, me doing the research and then reaching out to them to give a solution. This blog post is no different in that aspect.

Interview Question of the Week #013 – Stored Procedure and Its Advantages – How to Create Stored Procedure

March 29, 2015

Pinal Dave

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

SQL Stored Procedure

There are some questions which are so old that they should not be asked in the interview and gets old. Here is one of the questions I have spotted so many times in the interview that if co-interviewer asks to the candidate, I often feel bored (well, I was caught…