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 MoreSQL Server Education (by the geeks, for the geeks)
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 MoreA 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 MoreHere’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