Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have a simple table 
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.
There is 67k records so if one does math on the filled fields, it should not be that high.
Am I missing something?
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.
