Tag: columnstore

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 Indexes (Part 2)

by

Troubleshooting SQL Server 2016 Indexes (Part 2) If you have problems with SQL Server 2016 indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 1775 when create a foreign key constraint. This error indicates that you cannot create foreign key because it references object whose PRIMARY KEY index is disabled. To resolve this problem,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Understanding Database Indexes — (Part – 3)

by

Understanding Database Indexes – (Part – 3) Author: Basit A. Farooq Full-text indexes A full-text search is a word search based on character string data. The Microsoft Full-Text Engine for SQL Server creates and maintains a full-text catalog automatically when you enable a table for full-text search. For more information about full-text indexes, see SQL Server Books Online topic: “Populate […]

Continue Reading →
SQL Server

Understanding Database Indexes — (Part – 2)

by

Understanding Database Indexes – (Part – 2) Author: Basit A. Farooq Covering Index with included columns SQL Server 2005 introduces included columns in indexes also known as covering indexes. Included columns are non-key columns. Query performance improves when all columns in a query are included in the index as either key or non-key columns. The SQL Server Database Engine stores […]

Continue Reading →