I have a client with a table in their database that is 97 GB in size: 12 is the data, 84 is Unused space.
I'm unable to shrink the DB. The db is comprised of three columns:
1) int
2) nvarchar(250)
3) float
Question: I know int and nvarchar shouldn't be a problem. Does anyone know if Float would act like a char datatype, in the sense that it will reserve a set amount of space regardless of whether that space is physically used or not?
This is by far and away the largest table in the database. The next largest database is approximately 600 MB. Crazy.
Anyone have any ideas on how I can push out that unused space?
-Ovatvvon :-Q
I'm unable to shrink the DB. The db is comprised of three columns:
1) int
2) nvarchar(250)
3) float
Question: I know int and nvarchar shouldn't be a problem. Does anyone know if Float would act like a char datatype, in the sense that it will reserve a set amount of space regardless of whether that space is physically used or not?
This is by far and away the largest table in the database. The next largest database is approximately 600 MB. Crazy.
Anyone have any ideas on how I can push out that unused space?
-Ovatvvon :-Q