Showing posts with label Indexes. Show all posts
Showing posts with label Indexes. Show all posts
Wednesday, October 30, 2019

SQLSTATE 4200 Error 666 and what to do.

›
This morning I was greeted by the following message from a job email The maximum system-generated unique value for a duplicate group wa...
2 comments:
Tuesday, June 06, 2017

Having fun with maxed out uniqifiers on a non unique clustered index

›
I was reading the post SQL Server Non-Unique Clustered Indexes Are Evil! by the Lone DB In that post, the person created the following ...
Wednesday, May 10, 2017

Not sure that I like the message from Online Resumable Index Rebuild in SQL Server 2017

›
I was messing around with the Online Resumable Index Rebuild, this is new in CTP 2 of SQL Server 2017. I don't know that I like the out...
Thursday, March 15, 2007

Online Indexing Operations in SQL Server 2005 Whitepaper Available For Download

›
TechNet has made availabe a whitepaper that deals with Online Indexing Operations in SQL Server 2005. Introduced in SQL Server 2005 Enterpri...
Wednesday, February 28, 2007

Using ALTER INDEX…REBUILD To Rebuild A Clustered Index Does Not Rebuild Its Nonclustered Indexes By Default On SQL Server 2005

›
How many times have you asked/been asked the following question: Does rebuilding a clustered index rebuild nonclustered indexes? Well Ken He...
Monday, October 17, 2005

Do Not Drop And Create Indexes On Your Tables

›
When you do this the nonclustered indexes are dropped and recreated twice, once when you drop the clustered index and then again when you cr...