I have a very larre (and growing) table which contains a PK and another column of the type text.
The text column contains XML, and I wish to search for the occurance of the various XML tags in the table.
Currently I can use LIKE statements to pull out matches. Will I still be able to do this if the XML in the keeps getting longer?
And would it actually be quicker to use a full-text index or PATINDEX ?
Thanks!!