|
|
|
|
Sowohl die Antwort von KHoffmann als auch die von MStrasser waren sehr hilfreich. Leider kann ich nur eine der Antworten "akzeptieren". Vielen dank für eure Hilfe!
|
1. Use sp_spaceused, table, 1. That reports the table and each index separately. DIviding the data space used by the rowtotal will give you one value for the actual row length (not counting fragmentation, which is based on the lock scheme and activity).
2. Use sp_help table_name. That will give you another value , the intended or average row length. Using the info provided, do the simple arithmetic with the column lengths; then estimate what they will be re the Datatype changes you intend.
3. Note the variable length columns require 4 additional bytes each.
* If a column is Nullable, it is stored as Var Len.
4. Now create the new table (even temporarily), with the same columns, with the new Datatypes, and repeat (2). This will confirm your estimates.
5. sp_estspace has a different purpose.
|
|
|
4 + 20 = 24 Byte/Zeile
8060/24 = 335,8 = 335 Zeilen Pro Seite
100000/335 = 298,5 = 299 Seiten
299 * 8096(8KB) = 2420704B = 2,4 MB
exec sp_spaceused TabellenName
select sum(length) from syscolumns where id = object_id('TabellenName')
|
|
|
