About TempDB and the Version Store
We will take notes here regarding tempDB, the Verison Store and how tempDB is used. Some of the content here is derived from…
Read MoreCategory: Internals
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 More
PostgreSQL vs. SQL Server Notes
This blog will be where I post my PostgreSQL administration learning and it’s comparison to SQL Server from a SQL Server DBA’s viewpoint.…
Read More
Availability Groups: Things to remember
Here are a few things to remember when working with Availability Groups: Backup and Restore NOTE: Using the Recovery Advisor GUI in SSMS…
Read More
What is a .TUF file in the DATA folder?
The TUF files you see in the ..\DATA folder is a “transaction undo file” which contains modifications to the database that were not…
Read More
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]…
Read More
Resolving the “Backup detected log corruption in database”
I saw this in the SQL logs today. It looks like some corruption happened in the transaction log of a specific database. I…
Read More
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…
Read More
SQL Server Page Types Explained
Here is a great blog post explaining the different SQL Server page types and how they work: Understanding Pages and Extents Views –…
Read More
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…
Read More