Tag: UPDATE STATISTICS

Lessons learned updating 100 millions rows.

Chris Skorlinski [MSFT] Best Practices, Inside Replication October 10, 2011

Yes, post mostly Replication or High Availability topics, but I found this interesting enough to share on my ReplTalk blog. These are the troubleshooting and resolution we used to help a customer explore faster ways to update a 100 million row table. Problem Description Customer was running UPDATE query affecting 100 million rows. This query
Read More »

Update Statistics fails with Error Number:–1073548784 “Could not allocate space for object ‘dbo.SORT”

Chris Skorlinski [MSFT] Troubleshooting September 25, 2011

Error Number: -1073548784 Executing the query “UPDATE STATISTICS [dbo].[***********] WITH FULLSCAN ” failed with the following error: “Could not allocate space for object ‘dbo.SORT temporary run storage: 142101814116352’ in database ‘tempdb’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup,
Read More »