If you're not using the data of the column in criteria and just retrieving them it's better to put on a separate table and use the PK to join.
VARCHAR(MAX) can't be used on indexes but puts that data OFF page so you can have more columns IN page.
Use SSMS change table feature that will create a script (creating a temporary table and inserting the data there, renaming etc etc).
"If there's nothing wrong with me, maybe there's something wrong with the universe!"
No comments:
Post a Comment