About Collations in SQL Server
This post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an…
Read MoreThis post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an…
Read MoreBelow are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…
Read MoreThe 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]…
Read MoreA good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 2130
Read MoreI recently had to run a query for one of our developers where the script was inserting a number of rows. All went…
Read MoreHere is a great blog post by Kimberly Tripp on why using GUIDs as a PRIMARY KEY on a CLUSTERED index is a…
Read MoreHere is a good blog post on a comparison of VARCHAR(MAX) versus VARCHAR(N): Performance comparison of varchar(max) vs. varchar(N) Views – 2069
Read MorePASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
Read MorePASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
Read MorePASS 2015 10-26-30 Seattle WA Pre-Con Day 1 – 42 Tips to Performance Tuning, Optimization and Everything Pinal Dave TODO: Write missing index…
Read More