Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Combined Multiple .SQL files into One Single File

October 19, 2014

Here is an interesting problem which I enjoyed solving yesterday. There were multiple SQL Files in my one folder. When I had to send it to my friend I had to collect all the files into a folder and zip it to send it via email. My friend who was…

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

October 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…