|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
estimate table spaceshi guys,
sp_spaceused 'table1' I have two ntext columns in 'table1', by default, is sp_spaceused calculating space for ntext too? Hi Britney
All columns are included. You can see this for yourself: use pubs go select * into newtitles from titles go exec sp_spaceused newtitles, @updateusage= true go alter table newtitles add info ntext go update newtitles set info = replicate(title, 100) go exec sp_spaceused newtitles, @updateusage= true go HTH Kalen Delaney Show quote "Britney" <britneychen_2***@yahoo.com> wrote in message news:emryCsOpFHA.1044@tk2msftngp13.phx.gbl... > > hi guys, > > > sp_spaceused 'table1' > > I have two ntext columns in 'table1', > > by default, is sp_spaceused calculating space for ntext too? > > > > When NTEXT column is NULL, how come it still takes some spaces?
Show quote "Kalen Delaney" <replies@public_newsgroups.com> wrote in message news:ODCxkYQpFHA.3828@TK2MSFTNGP12.phx.gbl... > > Hi Britney > > All columns are included. You can see this for yourself: > > use pubs > go > select * into newtitles from titles > go > exec sp_spaceused newtitles, @updateusage= true > go > alter table newtitles add info ntext > go > update newtitles set info = replicate(title, 100) > go > exec sp_spaceused newtitles, @updateusage= true > go > > HTH > Kalen Delaney > > > "Britney" <britneychen_2***@yahoo.com> wrote in message > news:emryCsOpFHA.1044@tk2msftngp13.phx.gbl... >> >> hi guys, >> >> >> sp_spaceused 'table1' >> >> I have two ntext columns in 'table1', >> >> by default, is sp_spaceused calculating space for ntext too? >> >> >> >> > > > Kevin
LOB data (type text, ntext and image) is by default stored on separate pages outside the data rows. As soon as you update any rows with LOB data to anything, even null, SQL Server will allocate at least 2 additional pages to start keeping track of that data. FYI, for ANY fixed length data column, NULLs will take space. So a char(100) that contains NULL will take the full 100 bytes. HTH Kalen Delaney www.solidqualitylearning.com Show quote "kevin" <pearl***@hotmail.com> wrote in message news:%23OP4VFYpFHA.3380@TK2MSFTNGP12.phx.gbl... > > When NTEXT column is NULL, how come it still takes some spaces? > > > > > "Kalen Delaney" <replies@public_newsgroups.com> wrote in message > news:ODCxkYQpFHA.3828@TK2MSFTNGP12.phx.gbl... >> >> Hi Britney >> >> All columns are included. You can see this for yourself: >> >> use pubs >> go >> select * into newtitles from titles >> go >> exec sp_spaceused newtitles, @updateusage= true >> go >> alter table newtitles add info ntext >> go >> update newtitles set info = replicate(title, 100) >> go >> exec sp_spaceused newtitles, @updateusage= true >> go >> >> HTH >> Kalen Delaney >> >> >> "Britney" <britneychen_2***@yahoo.com> wrote in message >> news:emryCsOpFHA.1044@tk2msftngp13.phx.gbl... >>> >>> hi guys, >>> >>> >>> sp_spaceused 'table1' >>> >>> I have two ntext columns in 'table1', >>> >>> by default, is sp_spaceused calculating space for ntext too? >>> >>> >>> >>> >> >> >> > > >  |
|||||||||||||||||||||||
Other interesting topics