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 […]
Tag: rebuild index
Troubleshooting SQL Server 2014 Indexes (Part 1)
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 […]
Tips for using indexes in SQL Server 2012
Tips for using indexes in SQL Server 2012 Keep your indexes as narrow as possible. Because each index takes disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Check that index you tried to create does not already...
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
Register
Already a member? Log in here