0
Ambience:
- Windows Server 2008 (A: x64, B: x86)
- SQL Server 2008R2 on both.
The second column is the number of rows, the third column is the space occupied in KB.
Does anyone have any idea what might be causing this? (I’ve run out of ideas... )
0No answers
Browser other questions tagged sql-server
You are not signed in. Login or sign up in order to post.
For saying what each column is?
– Jefferson Quesado
Where I work, we have already had some difficulty of a lot of space being occupied by a process of much deletion and writing in the same table. It wasn’t a loaded table of meaning for the end user (it was used to detect changes in the database to sync bases), so we redesigned the system so we don’t need it anymore
– Jefferson Quesado
Jefferson columns are: tableName, tableNumber, space_occupied
– Nuno Nóbrega Batista
The problem is that on one of the servers with many more logs it is taking up immensely less space.
– Nuno Nóbrega Batista
Are the data types exactly the same? If you run a
datalengthin the text fields, will they have the same sizes? Even in a fieldvarcharit is possible to have white spaces at the end until the full size is completed.– Ismael
How is the database structure? Possessed ERI?
– Renato Junior