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

SQLAuthority News – Ahmedabad User Group Meeting February 21 2009

February 23, 2009

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

MVP, SQL Index, SQL User Group, SQLAuthority Author Visit

We had Ahmedabad SQL Server User Group meeting on February 21, 2009 and it was wonderful to see so many people showing up for meeting. Gradually our group is growing and more and more developers and DBA are showing up. We had two session in this meeting. From the feedback…

SQL SERVER – My Observation – Effect of Clustered Index over Nonclustered Index

February 21, 2009

Pinal Dave

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

SQL Constraint and Keys, SQL Index, SQL Scripts

Note: This article is re-write of my previous article SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index. I have received so many request that re-write it as it is little confusing. I am going to re-write this with simpler words. Query optimization is one art which…

SQL SERVER – Technical Articles – Performance Optimizations for the XML Data Type in SQL Server 2005

February 11, 2009

Pinal Dave

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

Best Practices, MVP, SQL Index, SQL XML

I always wanted to learn XML and its usage. My friend and fellow MVP Jacob Sebastian is expert in XML, so if you are interested in XML please visit his blog here. If you are interested in performance optimization for XML Data type in SQL Server following article is must…

SQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2

February 8, 2009

Pinal Dave

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

SQL Constraint and Keys, SQL Index, SQL Scripts

In my previous article SQL SERVER – Introduction to Force Index Query Hints – Index Hint I have discussed regarding how we can use Index Hints with any query. I just received email from one of my regular reader that are there any another methods for the same as it…

SQL SERVER – Introduction to Force Index Query Hints – Index Hint

February 7, 2009

Pinal Dave

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

SQL Constraint and Keys, SQL Index, SQL Scripts

This article, I will start with disclaimer instead of having it at the end of article. “SQL Server query optimizer selects the best execution plan for a query, it is recommended to use query hints by experienced developers and database administrators in case of special circumstances.” When any query is…

SQL SERVER – Quickest Way to – Kill All Threads – Kill All User Session – Kill All Processes

February 6, 2009

Pinal Dave

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

SQL Scripts, SQL Utility

More than a year ago, I wrote how to kill all the processes running in SQL Server. Just a day ago, I found the quickest way to kill the processes of SQL Server. While searching online I found very similar methods to my previous method everywhere. Today in this article,…

SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index

February 4, 2009

Pinal Dave

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

SQL Constraint and Keys, SQL Index, SQL Scripts

Today I came across very interesting observation while I was working on query optimization. Let us run the example first. Make sure to to enable Execution Plan (Using CTRL + M) before running comparison queries. USE [AdventureWorks] GO /* */ CREATE TABLE [dbo].[MyTable]( [ID] [int] NOT NULL, [First] [nchar](10) NULL,…