Disable Enable Indexes SQL Server
One of the most common questions on forums is how to disable enable indexes SQL Server. Index can be disabled or enabled as shown below USE AdventureWorks2014 GO — Query1: disable …
Read MoreTag: primary key
Primary key not null in SQL Server
A Jr. Developer asked me why a primary key not null in SQL Server. A primary key uniquely identifies a row in a table and a NULL can’t identify any row. …
Read MoreT-SQL find tables without primary key
Here’s a T-SQL find tables without primary key. SELECT OBJECT_SCHEMA_NAME(tables.object_id,db_id()) AS SchemaName, tables.name As TableName FROM sys.tables tables join sys.indexes indexes ON tables.object_id=indexes.object_id WHERE indexes.is_primary_key=0 GO The sys.indexes.is_primary_key column indicates whether …
Read More