How SQL Server processes a query
The logical order in which SQL Server parses a query and generates an execution plan: 1. FROM [left_table] 2. ON [join_condition] 3. [join_type]…
Category: Performance
Why using GUIDs as Primary Keys on a Clustered Index (Table) is a bad idea
Here is a great blog post by Kimberly Tripp on why using GUIDs as a PRIMARY KEY on a CLUSTERED index is a…
Why use of VARCHAR(MAX) should be avoided
Here is a good blog post on a comparison of VARCHAR(MAX) versus VARCHAR(N): Performance comparison of varchar(max) vs. varchar(N) Views – 584
PASS 2015 – Seattle WA – Day 3
PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch
PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
PASS 2015 – Seattle WA – Pre-Con Day 1 – Pinal Dave
PASS 2015 10-26-30 Seattle WA Pre-Con Day 1 – 42 Tips to Performance Tuning, Optimization and Everything Pinal Dave TODO: Write missing index…
About Trusted Foreign Key Contraints
I will post some of my findings about trusted foreign keys and constants here since this has become a minor issue at work.…
SQL Server Index Design Best Practices
This post is consisted of mostly direct quotes from the article posted at the bottom of the page. I put them here to…
Using DBCC SHOW_STATISTICS
This is a DBCC command I learned from Brent Ozar’s Indexing video. To get statistics on an index, simply use:
|
1 |
DBCC SHOW_STATISTICS ('Person.Person', IX_Person_LastName_FirstName_MiddleName); |
Views –…
Lock and Latch Compatibility Articles
Here is a good article describing what lock compatibility is all about as well as a few charts for reference: TechNET: Lock Compatibility…