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

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query

September 24, 2009

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

SQL Index, SQL Scripts, SQL White Papers

Recently, I was working on an optimization project for one of the large organizations. While working on one of the queries, we came across a very interesting observation. We found that there was a query on the base table and when the query was run, it used the index, which…

SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location

September 20, 2009

Pinal Dave

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

SQL Documentation

I was reading the blog of Ward Pond, and I came across another note of Microsoft. I really found it very interesting. The given explanation was very simple; however, I would like to rewrite it again. Let us execute the following script. This script inserts two values ‘A’ and ‘B’…

SQL SERVER – Converting Stored Procedure into Table Valued Function

September 17, 2009

Pinal Dave

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

SQL Function, SQL Stored Procedure

In one of my recent articles, I mentioned the use of Table Valued Function (TVF) instead of Stored Procedure (SP). I received a follow up email asking what type of SP can be converted into a TVF. This is indeed a very interesting question! In fact, not all the SPs…

SQL SERVER – Index Seek vs. Index Scan – Diffefence and Usage – A Simple Note

August 24, 2009

Pinal Dave

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

SQL Index, SQL Server

In this article we shall examine the two modes of data search and retrieval using indexes- index seek and index scan, and the differences between the two.

SQL SERVER – Get Query Plan Along with Query Text and Execution Count

August 21, 2009

Pinal Dave

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

SQL Scripts, SQL Server, SQL System Table

Quite often, we need to know how many any particular objects have been executed on our server and what their execution plan is. I use the following handy script, which I use when I need to know the details regarding how many times any query has ran on my server along with its execution plan. You can add an additional WHERE condition if you want to learn about any specific object.

SQL SERVER – Measure CPU Pressure – Detect CPU Pressure

August 17, 2009

Pinal Dave

SQL Performance

CPU Threads, SQL CPU, SQL DMV, SQL Scripts, SQL Server, SQL System Table

The CPU is responsible for not only SQL Server operations but also all the OS tasks related to the CPU. Let us learn about measuring CPU Pressure.

SQL Server – Understanding Table Hints with Examples

June 20, 2009

Pinal Dave

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

Query Hint, SQL Joins, SQL Scripts

Today we have a very interesting subject to look at. I tried to look for help online but have not found any other documentation besides what we have from the Book Online. Let us try to understand what are the different kinds of hints available in SQL Server and how…