SQL Tips and Tricks Archives - Page 160 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Search Records with Single Quotes

October 20, 2014

Every day when I woke up there are hundreds of emails with various questions related to SQL. I spend my first hour of the day answer each of them. How do I search records with single quotes in it? Here is the answer to find records with single quotes in…

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

October 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Batch

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 – 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…