Partition columns for a unique index must be a subset of the index key

Error: Column ‘xxxxx’ is partitioning column of the index ‘PK_xxxxxxxx’. Partition columns for a unique index must be a subset of the index key. Could not create constraint or index. Solution: Since both biTable01Id, dtStartDateTime columns are in the partition column, both must be in the Primary Key column as well.

Create Index Status Monitor Progress

Starting with SQL Server 2014 a new troubleshooting capability is to monitors real time query progress with the DMV sys.dm_exec_query_profiles which is the base for Live Query Statistics new functionality for SQL Server 2016, there are two ways to enable real time query monitoring: Session scope: By enabling SET STATISTICS XML ON; or SET STATISTICS PROFILE ON;... » read more

Error: You are debugging a release build

Error: For some reason, when I launch this application in the debugger using the normal Start Debugging command in Visual Studio, it launches, but it also produces the following warning: Resolution: Disable this option under Debug->Options->Suppress JIT optimization on module load (Managed only). Sources: https://stackoverflow.com/questions/38601643/error-you-are-debugging-a-release-build-of-x-dll