It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Issues with changing from NTEXT to NVARCHAR(MAX)?

I'd like to set up some indexes that contain some fields in the INCLUDE portion of the index. Being that the fields are NTEXT, they cannot be used. It's an easy change to alter the fields, but I'm wondering if anyone has done this before and ran into any issues?

The particular table I'm looking at is changeitem. We have a lot of queries that reference this table and setting up a better index would reduce the processing time and number of reads.
Here is the index I'm thinking of setting up provided I change OLDVALUE, OLDSTRING, NEWVALUE and NEWSTRING from ntext to nvarchar(max)

CREATE INDEX idx_chgitem_group_field_v2 ON dbo.changeitem (groupid, FIELD)
INCLUDE (FIELDTYPE, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING)

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you