A quick count said 8 partitions, but the table has 4. Here is where the extra rows came from and how to spot empty partitions.
SQL SERVER – Handling XML Documents – Notes from the Field #125
Stuart Ainsworth shares a client case of importing XML documents into a staging table and what he learned about using XQuery methods in SQL Server.
SQL SERVER 2016 – Management Studio Highlighting Current Line Option
Something felt odd in SSMS 2016: the current line highlight. Here is the option that controls Highlighting Current Line and how to change it.
Comparison – Logical Architecture between Oracle and SQL Server
Continuing my Oracle vs SQL Server series, I compare the Logical Architecture of both, using simple analogies to map what you know to what you don’t.
SQL SERVER – Steps to Migrate Clustered Disk / LUN
This was a clustered instance, so we need to take care of dependency also. Here are the steps which I have outlined for Migrate Clustered Disk.
SQL SERVER – FIX: SQL Profiler Error – Cannot Retrieve Trace Definition for SQL Server Version
Profiler on SQL Server 2016 showed an empty message box, then ‘Cannot retrieve trace definition for SQL Server version’. How I fixed this SQL Profiler Error.
SQL SERVER – Understanding FAILOVERCLUSTERROLLOWNERSHIP with SQL Server Cluster Rolling Upgrade
I started to hunt in the blog and saw there were a number of posts around (FAILOVERCLUSTERROLLOWNERSHIP) the cluster that caught my eyes: