What are forwarded records in SQL Server? It is an old concept, yet few new DBAs know it. Here is a short answer about heap rows that moved to a new page.
SQL SERVER – Unable to Bring SQL Online – DoSQLDataRootApplyACL : Failed to Create Directory Tree at SQLDataRoot
Unable to bring SQL Online on a cluster node? The cluster log showed DoSQLDataRootApplyACL failed to create directory tree at SQLDataRoot. Here is the fix.
SQL SERVER 2016 – Creating Clustered ColumnStore with InMemory OLTP Tables
While preparing my SQLPASS session on SQL Server 2016, I explored creating clustered ColumnStore with InMemory OLTP tables. Here is what I learned.
Does Dropping Primary Key Drop Non-Clustered Index on the Column? – Interview Question of the Week #085
Does dropping a primary key also drop the Non-Clustered Index on that column? An interview question with a small repro script to see the answer.
How to Drop Clustered Index on Primary Key Column? – Interview Question of the Week #084
DROP INDEX fails with Msg 3723 on a primary key. Here is how to drop clustered index on a primary key column the right way, through the constraint.
Does Dropping Clustered Index Drop Primary Key on the Same Column? – Interview Question of the Week #083
Does dropping clustered index also drop the primary key on the same column? Here is the short answer, a follow-up to last week’s question on the reverse case.
Does Dropping Primary Key Drop Clustered Index on the Same Column? – Interview Question of the Week #082
When you drop a primary key, does it drop the clustered index on the same column too? Yes, it does. Here is a small script that shows it.