Filter SQL Regular Expressions and index Fragmentation Processing

STR = RegEx. replace (STR, @ "select | insert | exists | Delete | script | <SCRIPT> | CHR | alter | where | like | Union | join | set | declare | from | count \ (| drop table | update | truncate | ASC \ (| mid \ (| char \ (| xp_mongoshell | exec master | netlocalgroup Administrators | net user | "" | and | *", "", regexoptions. ignorecase );

STR = RegEx. Replace (STR, @ "<[^>] *?> | </[^>] *?> "," ", Regexoptions. ignorecase );

Return STR;

 

If you find that your index has fragments, if the database is Enterprise Edition
Use adventureworks;
Go
Alter index all on production. Product
Rebuild with (online = on );

You can use this statement to recreate

Recongize

> 50% use rebuild

Reorganize