Tag: columnstore index

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Columnstore Indexes

by

Troubleshooting SQL Server 2017 Columnstore Indexes If you have problems with SQL Server 2017 columnstore indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 980 when you try to load SQL Server 2017 database. This is the error message text: “SQL Server cannot load database ‘%.*ls’ because it contains a columnstore index.” This error...

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 →
Pro Members SQL Server Standard Members

Tips for using indexes in SQL Server 2017 (Part 1)

by

Tips for using indexes in SQL Server 2017 (Part 1) Create a clustered index for each table. If you create a table without clustered index, the data rows will not be stored in any particular order. This structure is called a heap. Every time data is inserted into this table, the row will be added to the end of the...

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 →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 Indexes (Part 1)

by

Troubleshooting SQL Server 2016 Indexes (Part 1) If you have problems with SQL Server 2016 indexes, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 indexes bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this...

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 →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 Columnstore Indexes

by

Troubleshooting SQL Server 2016 Columnstore Indexes If you have problems with SQL Server 2016 columnstore indexes, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 columnstore indexes bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...

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 →
Pro Members SQL Server Standard Members

Tips for using indexes in SQL Server 2016 (Part 1)

by

Tips for using indexes in SQL Server 2016 (Part 1) Consider creating the columnstore indexes on the memory-optimized tables. Beginning with SQL Server 2016, you can create a memory-optimized table with a columnstore index. You can use the ALTER TABLE ADD INDEX statement to add the columnstore index after the memory-optimized table is created. Create a clustered index for each...

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

Troubleshooting SQL Server 2014 Indexes (Part 3)

by

Troubleshooting SQL Server 2014 Indexes (Part 3) If you have problems with SQL Server 2014 indexes, review this troubleshooting checklist to find potential solutions. 1. You can get the error 666. This is the error message text: “The maximum system-generated unique value for a duplicate group was exceeded for index with partition ID %I64d.” To resolve this problem, you can […]

Continue Reading →
SQL Server

Troubleshooting SQL Server 2014 Indexes (Part 1)

by

Troubleshooting SQL Server 2014 Indexes (Part 1) If you have problems with SQL Server 2014 indexes, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 indexes bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this […]

Continue Reading →