2
votes
1answer
187 views

What exactly is “pinning” in relation to indexes? [closed]

When one talks about "pinning" in indexes, what exactly is this? Is there some other word/term I can search for, as google has not provided any solutions. It is part of a test question, where ...
2
votes
3answers
2k views

How remove/de-index a page from Google? [closed]

On the results page when I Google "e-luminate", the 3rd and 4th link seems to point to specific directory deep within the folders which stores the images. How can I get rid of these 2 results from ...
3
votes
1answer
1k views

Mysql auto_increment reset WITHOUT rebuilding index?

There just HAS to be a way to reset the auto_increment value on a table without rebuilding the entire index. I have a table with over 2 billion rows in it that accidentally got an ID inserted into it ...
8
votes
2answers
2k views

Correct value for fill factor for clustered indexes with surrogate identity keys

I have a large table which has a clustered index with an identity primary key. I'm deciding on the correct value for the fill factor for this table to minimise page splits. We maintain indexes using a ...