Some database design guidelines and best practices
Below are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…
Category: Performance
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]…
Why using GUIDs as Primary Keys on a Clustered Index (Table) is not a good idea and some alternative approaches
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 – 1090
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 –…