The limitations of the missing index feature – It does not suggest filtered indexes

By |2019-07-07T16:12:00+00:00Juli 7th, 2019|Categories: Performance|Tags: |

This will be my last blog about the limitations of the missing index feature. This time I will demonstrate that the missing index feature will not suggest filtered indexes. Filtered indexes reduce the index size and thus the storage allocation in the data file is reduced. Rebuilding or reorganizing these indexes also requires fewer resources. So it's worth creating filtered indexes when possible. The following example will prove that the missing index feature will not consider creating filtered indexes.

Kommentare deaktiviert für The limitations of the missing index feature – It does not suggest filtered indexes

The limitations of the missing index feature – It suggests creating indexes on imprecise and not persisted columns

By |2019-07-07T16:24:57+00:00Juni 16th, 2019|Categories: Performance|Tags: |

(Dieser Artikel ist derzeit nur auf Englisch verfügbar) This will be my penultimate blog about the limitations of the missing [...]

Kommentare deaktiviert für The limitations of the missing index feature – It suggests creating indexes on imprecise and not persisted columns

Zeit für eine neue Herausforderung: Senior Program Manager Microsoft SQL Server Security Team

By |2019-07-07T16:23:54+00:00September 7th, 2018|Categories: Conferences, News, Security, Seminar|Tags: , |

Dieser Blog-Post ist gewissermaßen der Anfang von einem Ende, und markiert andererseits auch einen Neuanfang: ... ich mich entschieden ein tolles Angebot von Microsoft anzunehmen, und zum Redmonder SQL Server Security Team zu wechseln.

Kommentare deaktiviert für Zeit für eine neue Herausforderung: Senior Program Manager Microsoft SQL Server Security Team