sql server, is it possible to determine how much s...
# sqlw
websolete
10/23/2023, 5:29 PMsql server, is it possible to determine how much storage a particular column in a table is consuming (rather than the table as a whole)?
p
Patrick
10/23/2023, 5:39 PMYea I believe its
SELECT DATALENGTH(yourcolumn) AS daSizew
websolete
10/23/2023, 5:48 PMthanks, was hoping there was a dmv for it
websolete
10/23/2023, 5:48 PMthe table is 15gigs and most of it is in one col
s
Scott Steinbeck
10/23/2023, 5:55 PMis it a json column?
w
websolete
10/23/2023, 5:56 PMvarchar(max) but used for json storage. not json datatype per se