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.
Logical Architecture: Oracle and SQL Server Compared
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.
Primary Key and Null in SQL Server – Interview Question of the Week #071
Can a primary key contain NULL values? No. Here is why primary key and NULL do not mix, and the simple interview question many candidates miss.
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.