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 !
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.