Sep 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Error Messages, SQL Index, SQL Scripts
In one of my recent training course, I was asked question regarding what is the importance of setting IGNORE_DUP_KEY = ON when creating unique nonclustered index. Here is the short answer: When nonclustered index is created without any option the default option is IGNORE_DUP_KEY = OFF, which means when duplicate…
Read More

SQL SERVER – Difference Temp Table and Table Variable – Effect of Transaction

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Transactions
Few days ago I wrote an article on the myth of table variable stored in the memory—it was very well received by the community. Read complete article here: SQL SERVER – Difference TempTable and Table Variable – TempTable in Memory a Myth. Today, I am going to write an article…
Read More

SQL Authority News – Training SQL Server Query Optimization And Performance Tuning

Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Training

Earlier this year we had offered Query Optimization course and it was sold out in minutes. Due to popular demand we are offering the same course in the very first week of next year. The title of the course is ‘MS SQL Server Query Optimization And Performance Tuning‘.

This three day course is an intensive course designed to give attendees an in-depth look at the query optimization and performance tuning concepts and methods found in SQL Server. This course is designed to prepare the SQL Server developers and administrators for a transition to SQL Server while discussing best practices for a variety of topics.

Read More

SQL SERVER – 2008 Star Join Query Optimization

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
Best Practices, Business Intelligence, Data Warehousing, SQL Joins
Business Intelligence (BI) plays a significant role in businesses nowadays. Moreover, the databases that deal with the queries related to BI are presently facing an increase in workload. At present, when queries are sent to very large databases, millions of rows are returned. Also the users have to go through…
Read More

SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, SQL Documentation, SQL Download, SQL White Papers
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments. Enhancing Query Performance – Query performance directly impacts the quality of the end user experience. As such, it is the primary benchmark…
Read More