Below is the sample in how to reproduce a recursive parent-child relationship and how to find out which records are the troublesome one CREATE TABLE RecursiveSample ( REF INT NOT NULL, PARENT_REF INT NOT NULL, NAME…
How to simulate Deadlock in SQL Server, pretty simple 1. Create a table CREATE TABLE MyDeadlockTable ( REF INT PRIMARY KEY NOT NULL, NAME VARCHAR(255) ) GO 2. Populate a table with the record INSERT INTO…
I’ve just found that Microsoft has just released a repository for all scripts which are driven by Technet script repository and Microsoft Customer Script & Support, the sample scripts are based on the real world scenario…