The tag has no wiki summary.

learn more… | top users | synonyms

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 ...
3
votes
4answers
774 views

Recommended SSD Setup

I'm building a new server which will be running a text search service for our online web services. This service requires fast IO so I am trying to further reduce any potential bottlenecks. I would ...
2
votes
3answers
2k views

Large insert/update in table causes timeout while SQL Server re-arrange indexes

We insert/delete about 1 million rows of a two million rows table with SSIS. We have 20 indexes on this table. Right after the SSIS finished, we're experiencing timeouts in the frontend. The ...