THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Page Free Space

See also my SQL Server technical articles on SQLperformance.com

Enforcing Uniqueness for Performance

Published Friday, July 29, 2011 5:38 AM by Paul White

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Amit Banerjee said:

This is what you call a quick post? It's so short!! :P

Good point. I had written about confusing nature of scan count in the STATISTICS IO output sometime back.

July 28, 2011 12:08 PM
 

Paul White said:

Thanks Amit, I have added links to your MSDN entries - everyone should read them.

Paul

July 28, 2011 12:23 PM
 

Meher said:

Thanks Paul. Very nice post. You explained it in simple lnaguage and I like it. Amit also has a good post. Thanks to both of you.

Meher

July 28, 2011 5:28 PM
 

ALZDBA said:

Rule no 1: Tell your system what you know ! If you know it is unique, declare it as unique ! ( If it must be unique, it is considered a constraint and should be declared to meet the constraint )

Nice read. Good refs.

Thanks

July 28, 2011 6:03 PM
 

WayneS said:

ALZDBA - I really like your rule.

July 30, 2011 2:07 PM
 

Paul White: Page Free Space said:

In my last post , I showed how using a index unique could speed up equality seeks by around 40%. For

August 3, 2011 8:34 AM
 

kristina said:

It has been some time since I visited website with such high quality information. Thank you so much for providing such helpful information. This is really informative and I will for sure refer my friends the same. Thanks.

July 11, 2012 11:43 PM

Leave a Comment

(required) 
(required) 
Submit
Privacy Statement