SQL Performance Archives - Page 54 of 100 - SQL Authority with Pinal Dave

SQL SERVER – TechEd India 2013 Sessions and Relevent Pluralsight Courses

March 19, 2013

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

I am presenting at TechEd India 2013 two SQL Server session. You can read about my session in this blog post. Yesterday I presented on topic SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions. Today I will be presenting on the subject Indexes – The Unsung Hero. If you are at…

SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek

March 12, 2013

Pinal Dave

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

SQL Function, SQL Index

“Don’t use functions in the WHERE clause, they reduce performance.” I hear this quite often. This is true but this subject is hard to understand in a single statement. Let us see what it means and how to use the function in the WHERE clause. We will be using sample…

SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query

January 28, 2013

Pinal Dave

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

Query Hint, SQL Lock

In earlier blog post SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query, we learned how we can use NOWAIT query hint to not wait on any locked query and return error. The Query Hint works on query and table level. There is…

SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query

January 25, 2013

Pinal Dave

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

Query Hint, SQL Lock

Everybody knows about NOLOCK but not everyone knows about NOWAIT. They are different and they have an entire different purpose. In this blog post we will not talk about NOLOCK but we will see how NOWAIT will work. The idea of writing about blog post is based on the question…

SQL SERVER – Introduction of Showplan Warning

January 15, 2013

Pinal Dave

SQL Performance

Execution Plan, SQL Scripts, SQL Server

Vinod Kumar M is my very good friend, renowned SQL Server Expert. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Before joining Microsoft, he was a Microsoft MVP for SQL Server for more than 3 years. He now works with MTC as a Technology Architect. He is a well-known speaker at all major Microsoft and third party technical conferences. Here is a very interesting blog post he sent on the subject of Executon Plan. Let us learn about introduction to Showplan Warning.

SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar

November 15, 2012

Pinal Dave

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

This guest post is by Vinod Kumar. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Working on various versions from SQL Server 7.0, Oracle 7.3 and other database technologies – he now works with the Microsoft Technology Center (MTC) as a Technology Architect.…

SQL SERVER – Find Rows and Index Count – SQL in Sixty Seconds #029 – Video

October 10, 2012

Pinal Dave

SQL Performance

Clustered Index, Database, SQL in Sixty Seconds, SQL Index, SQL Scripts, SQL Server Management Studio

There are a few questions I often get asked. I wonder how interesting is that in our daily life all of us have to often need the same kind of information at the same time. Here is the example of the similar questions about index count: