Thank for all participants attending my sessions in Mainz. As promised, here are the slide decks and demos I used during my presentations. If you have any question to this are other SQL Server related topics, feel free to ping me. I am looking forward to hear from you !

Volltext voraus – Volltextindizierung in SQL Server

Implement now – performance later

BTW, I didn’t forget the question I put in my backlog.

  • If a table is partitioned and I have fulltext-indexed the table, will be switch off eliminate the relevant parts within the fulltext index, leaving me with consistent results ?
    • Yes, as the fulltext index only sees the logical parts of the table, it will wipe out all entries of the switched out data directly and permanently.