Lessons learned updating 100 millions rows.

Lessons learned updating 100 millions rows. Chris Skorlinski Microsoft SQL Server Escalation Services 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….

1

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

Update Statistics fails with Error Number: –1073548784 “Could not allocate space for object ‘dbo.SORT” Chris Skorlinski Microsoft SQL Server Escalation Services · ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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…

0