I have a simple table enter image description here

and I have blanked out the twitterdetail and rawsource and set it as null so there is no data in them, however the space for that table is 350mb. enter image description here

There is 67k records so if one does math on the filled fields, it should not be that high.

Am I missing something?


1 Answer 1


It's hard to say anything definitive without knowing how the table was defined or what you did to "blank out" the columns, but NULLs still take up space and you still have an NVARCHAR(MAX) MatchedKeywords column which could be taking up plenty of space.

Sometimes tables can change in size after a REBUILD. If you feel that the table is taking up too much space right now I suggest trying that.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.