Showing posts with label Performance Tuning. Show all posts
Showing posts with label Performance Tuning. Show all posts
Wednesday, October 11, 2017

Sargable Queries...

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
Thursday, October 05, 2017

Data types storage differences

›
It has been a while since I wrote some of my best practices posts. I decided to revisit these posts again to see if anything has changed, I...
1 comment:
Friday, November 04, 2016

Are your foreign keys indexed? If not, you might have problems

›
When you add a primary key constraint to a table in SQL Server, an index will be created automatically. When you add a foreign key const...
Sunday, August 17, 2008

Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code

›
Take a look at this query. SELECT * FROM ( SELECT customer_id, ‘MTD’ AS record_type, COUNT ( * ) , SUM ( … ) , AVG ( … ) FROM payment_t...
Sunday, December 16, 2007

EXISTS or COUNT(*)

›
Do you use this IF ( SELECT COUNT (*) FROM SomeTable WHERE SomeColumn = SomeValue ) > 0 Or do you use this IF EXISTS ( SELECT * FRO...
Monday, October 15, 2007

Interview With Kalen Delaney About Inside Microsoft SQL Server 2005 Query Tuning and Optimization

›
I am a big fan of Inside Microsoft SQL Server 2005 The Storage Engine so when I saw that yet another book got published in this series I ju...