Space Problems

Question

Space Problems

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Tom Goltl SSCertifiable Points: 5755 More actions · Answer 1

I'm wondering if someone didn't corrupt the file(xls) and change the column types. Have you tried creating a new xls template for importing. Is everyone having problems with import or just certain computers/individuals.

Tom

ScottPletcher SSC Guru Points: 100949 More actions · Answer 2

To be sure, make SQL update the page (and row) usage counts and see if there are any large discrepancies:

DBCC UPDATEUSAGE ( '<your_db_name>' )

SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

Animal Magic SSChampion Points: 13964 More actions · Answer 3

jumping in late on this one and sorry if this has been covered already. I read recently about free space in heaps (tables without a clustered index). Apparently SQL never releases the space back from the table to the database during updates and deletes and instead uses an internal pointer system to let SQL know where to find records. here[/url]is a link to Brent Ozar page, have a look at the Captive pages part.

If you are doing these bulk inserts into the same heaps this could be your reason. I am unsure (as it doesn't mention in the article nor have i tested it myself) on what affect this has on free space statistics fed back from SQL, but it could well be worth a look into if you are using heaps.

John

M. Gamito SSC Enthusiast Points: 199 More actions · Answer 4

ScottPletcher (12/26/2014)
To be sure, make SQL update the page (and row) usage counts and see if there are any large discrepancies:
DBCC UPDATEUSAGE ( '<your_db_name>' )

I did this, the pages were updated but the size did'nt change.

Any idea?

M. Gamito SSC Enthusiast Points: 199 More actions · Answer 5

I will try to backup and restore this db.

Lets see if this will work.