The most important performance-tuning technique available is having the needed indexes created on the tables to ensure that the SQL Server database engine is able to get the data that it needs to ...

When an index facet is changed (e.g. the fill factor), EF currently generates a migration that drops and then recreates the index. First, we should add support for ALTER INDEX, which would be the ...

We are delighted to announce that Resumable Online Index Rebuild is now available for public preview in the SQL Server vNext 2017 CTP 2.0 release. With this feature, you can resume a paused index ...