When should you use a Unique Index and when a Unique Constraint? Imran Mohammed explains, and shows how to handle a column with more than one NULL.
SQL SERVER – Find Primary Key Using SQL Server Management Studio
Need to drop a primary key but do not know the constraint name? Imran Mohammed shows how to find primary key details using SQL Server Management Studio.
SQL SERVER – 2008 – Creating Full Text Catalog and Full Text Search
Set up Full Text Search in SQL Server 2008 in three steps: create a full-text catalog, create the full-text index, then populate it. Screenshots for each step.
SQL SERVER – Introduction to Filtered Index – Improve performance with Filtered Index
A Filtered Index in SQL Server 2008 indexes only some rows of a table, which can speed up queries and cut index storage and upkeep. Example on the Employee table.
Recursive CTE Performance: Index the Child Lookup
Recursive CTE performance depends on finding the next children efficiently. Compare identical rows and actual plans before accepting an index change.
SQL SERVER – 2008 – Introduction to Online Indexing Operation
An introduction to online indexing in SQL Server, which lets you create or rebuild an index while the table stays available to your app.
SQL SERVER – Effect of Order of Join In Query
Does the order of join in a query change the result? With AdventureWorks, I show two queries that return the same rows, only in a different order.