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

SQL SERVER – Finding Max Value From Multiple Values

October 17, 2014

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…

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…

SQL SERVER – Finding Max Value From Multiple Values

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

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

SQL SERVER – SQL Server 2008 Service Pack 4 – Download

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

SQL SERVER – Row Offset in SQL Server For Different Version

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

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