A Jr. developer asked if a clustered index can live on a separate Drive from its table. The answer is no, and the clustered vs non clustered difference shows why.
Preventing Overbooking When Two Sessions Grab the Last Seat
Learn preventing overbooking through a last-seat race, an atomic update, update locks, and a database constraint that rejects oversold inventory.
SQL SERVER – Difference Between Candidate Keys and Primary Key
What is the difference between a candidate key and a primary key? A table can have many candidate keys, but only one of them becomes the primary key.
SQL SERVER – How to Drop Primary Key Constraint
ALTER TABLE … DROP PRIMARY KEY is MySQL syntax and fails in SQL Server with Msg 156. Here is how to drop primary key constraint the SQL Server way.
SQL SERVER – 2008 – Find Relationship of Foreign Key and Primary Key using T-SQL – Find Tables With Foreign Key Constraint in Database
A T-SQL script that finds every table with a foreign key constraint and shows how each foreign key relates to its primary key, now with schema names.
SQL SERVER – My Observation – Effect of Clustered Index over Nonclustered Index
A simpler rewrite of my observation on the effect of clustered index over nonclustered index, with a sample script and execution plans to compare in SSMS.
SQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2
Part 2 on force index query hints: instead of the inline WITH table hint, use the OPTION clause at the end of the query and name the table for each hint.