July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Clustered Index on Separate Drive From Table Location

Pinal Dave
SQL Performance
Best Practices, SQL Constraint and Keys, SQL Index, SQL Server

How to improve performance of SQL Server Queries is a common topic of discussion among many of us. Much has been said, much has been discussed. Few days back, I had an interesting discussion with one of the Junior developers regarding performance improvement of SQL Server Queries. We discussed on how by using a separate hard drive for several database objects can right away improve performance. I suggested him that non clustered index and tempdb can be created on a separate disk to improve performance.

Read More

SQL SERVER – 2008 – Find Relationship of Foreign Key and Primary Key using T-SQL – Find Tables With Foreign Key Constraint in Database

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts
While searching for how to find Primary Key and Foreign Key relationship using T-SQL, I came across my own blog article written earlier SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database. It is really handy script and not found written on line anywhere. This is…
Read More

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

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