I have personally implemented the solution suggested of resolving contention about creating an index with OPTIMIZE_FOR_SEQUENTIAL_KEY at my client’s place.
SQL SERVER – Last Page Insert PAGELATCH_EX Contention Due to Identity Column
Today’s goal is to understand what is the Last Page Insert PAGELATCH_EX Contention Due to Primary Key. Let us start understanding it together.
SQL SERVER – Show Primary Key for a Single Table – sp_pkeys
Recently, one of my clients showed me a very cool trick to check Primary Key for a single table with the help of the system stored procedure sp_pkeys.
What is Trusted Constraint in SQL Server? – Interview Question of the Week #210
Question:Â What is Trusted Constraint in SQL Server?
How to Create Primary Key Without ANY Index? – Interview Question of the Week #143
Question: How to Create Primary Key Without ANY Index?
SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns
Unique key on a column is used to identify a particular row easily. It is created either by explicitly mentioning it either part of the definition or when defined as Primary key (By default it is unique and not null). Let us learn about special stored procedure sp_special_columns customers today.
How to Allow Only Alphabets in Column? – Interview Question #136
Question:Â How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question.