Mikhail Gorbachev's policies of glasnost and perestroika had profound and unintended effects on the Soviet Union. In fact, many historians suggest these reforms led directly to the fall of communism and the breakup of the Soviet Union.
In SQL Server, you create a surrogate key by assigning an identity property to a column that has a number data type. A natural key is a naturally occurring descriptor of the data and one of a table's attributes that has no duplicate values. When you use a natural key as a table's primary key, each of the table's rows is uniquely identified.
Lock Granularity. 1  SQL Server can lock resources at the table, page, partition or row level. 2  If locks are escalated, SQL Server can also lock a single partition of a table or index. 3  SQL Server can also lock index keys and ranges of index keys if needed. Intent Locks. 2  As the name suggests is a pre-qualifiers to shared/update/exclusive locks. 3  Since SQL Server can acquire locks at different levels, before the process completes or the statements completes SQL Server might want to know if locks are already acquired.