July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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

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…
Read More

SQL SERVER – 2008 – Download Microsoft SQL Server 2008 Express with Tools Free

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Database, SQL Download, SQL Server Express, SQL Utility
Note: Download Microsoft SQL Server 2008 Express with Tools Free by Microsoft SQL Server 2008 Express Edition was much awaited version of SQL Server 2008. It is FREE and available to download from web. Microsoft SQL Server 2008 Express with Tools (SQL Server 2008 Express) is a free, easy-to-use version…
Read More

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

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…
Read More
All Articles nic1-500x400

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

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,…
Read More