Join GitHub today
GitHub is home to over 31 million developers working together to host and review code, manage projects, and build software together.Sign up
sp_BlitzIndex truncation error #1973
Reported via email by a user, copy/pasting into email here (he can chime in if he wants to be publicly named):
_sp_BlitzIndex failed with a truncation error which I've narrowed down to row 1843;
It is being inserted into an NVARCHAR(4000) column and so throws an error if there are a large number of partitions present. In my case we have over 900 partitions on one table....on a SQL 2008 database.
Code altered to;
...and all works again._