All Articles - SQL Authority with Pinal Dave

EXCEL / SQL SERVER – Extract the Domain from an Email Address

October 18, 2014

Just like any business person, I work with Excel pretty much half of my time when I am not working with SQL Server. Recently I faced challenges when I wanted to extract domain from the email address. I was using excel. I was in extreme rush so I did something…

SQL SERVER – Finding Max Value From Multiple Values

October 17, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is a question which I have received a few days ago. “I have three different variables, I want to find out which one of them has the maximum or highest value. How can I do that? I know I can do this with the IF or CASE statement, but…

SQL SERVER – Do You Know Your Data’s Classification? – Notes from the Field #050

October 16, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Notes from the Field

[Notes from Pinal]: Data is a very simple word, yet it is very powerful. There is a famous saying – Know Your Data. I have quite often found that developers do not know their data, they are often confused with the same and not sure how to answer that. My…

SQL SERVER – Beginning Reading Transaction Log File

October 15, 2014

Pinal Dave

SQL

Devart, SQL Log, SQL Scripts, SQL Server

In this article we will examine what the SQL Server Transaction Log is, why do we need one and how it works.

SQL Authority News – Save USD 600 for SQL Live! 360 in November

October 14, 2014

Pinal Dave

SQL

SQL Server, SQLAuthority Author Visit

I love talking about performance tuning and I love teaching about performance tuning. I think this is one subject, which everyone would like to discuss about, as this subject never gets old. I stay in India so I often deliver conference sessions on this subject over here. However, if you are in the USA, this is your opportunity to join me to discuss about SQL Server Performance. I’ll be speaking at Live! 360, November 17 – 21 in Orlando, FL. Live! 360 brings together five conferences, and the brightest minds in IT and Dev, to explore leading edge technologies and conquer current ones. More info:

SQL SERVER – What is the Difference Between An INNER JOIN and WHERE Clause

October 13, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins

Just received a question in email: “What is the Difference Between An INNER JOIN and WHERE Clause?” Well, the answer can be quite long but I will try to answer in few words and a very simple one. If you are talking about resultset – there will be not much…

SQL SERVER – SQL Server 2008 Service Pack 4 – Download

October 12, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

It has been a long time since SQL Server 2008 got Service Pack Update. Microsoft has finally released SQL Server 2008 service pack 4 and its feature pack. SQL Server 2008 SP4 contains fixes to issues reported as well as Hotfix solutions have provided since SQL Server 2008 Service Pack…

SQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table

October 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity, SQL Scripts

Question: Is it possible to add an auto incremental identity column to any table in SQL Server after creating a table. Answer: There are two answers – No and Yes. Let us see them one by one. Answer No – If you have an integer column in your table and…

SQL SERVER – Row Offset in SQL Server For Different Version

October 10, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

A very common question is how to find row offset in SQL Server. Here are a few examples based on different version of SQL Server. I have included SQL Server 2000 event, though it is almost 15 years old product and I encounter is less and less every day on…

SQL SERVER – Tuning Queries is Sometimes Waste of Time – Notes from the Field #049

October 9, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Server Security

[Note from Pinal]: This is a 49th episode of Notes from the Field series. Every day I get few emails where I am asked how to tune queries so the entire server run faster. I always end up writing long answer this question. The reason is simple – query tuning…