Why should I rebuild a table after dropping or adding a column?

Posted by: Simple Talk, on 19 Feb 2009 | View original | Bookmarked: 0 time(s)

The amount of space used by table rows can be important, and there are good articles on the web that show ways to estimate the amount of space that a table row uses. However, the actual space used by a table row could be more than what we would have calculated. The problems come when we modify the schema of a table....

Advertisement
Free Agile Project Management Tool from Telerik
TeamPulse Community Edition helps your team effectively capture requirements, manage project plans, assign and track work, and most importantly, be continually connected with each other.
Category: XSD | Other Posts: View all posts by this blogger | Report as irrelevant | View bloggers stats | Views: 1146 | Hits: 62

Similar Posts

  • Horizontal Table for your reports more
  • Reporting Release History : Q2 2009 SP1 (version 3.1.9.807) more
  • Issue with ADO.NET Sync Services and SQL Server 2000 more
  • SQL Server 2005/ SQL Server 2008 - Rebuild or Reorganize ALL Indexes in a Database more
  • Implementing SqlBulkCopy in Linq to Sql more
  • Adding simple trigger-based auditing to your SQL Server database more
  • Oracle Database Naming Guidelines more
  • Show Indexes for a Schema Owner more
  • The Remaining Nine "Working with Data in ASP.NET 2.0" Tutorials more
  • Beware ye of ancient columns more

News Categories

.NET | Agile | Ajax | Architecture | ASP.NET | BizTalk | C# | Certification | Data | DataGrid | DataSet | Debugger | DotNetNuke | Events | GridView | IIS | Indigo | JavaScript | Mobile | Mono | Patterns and Practices | Performance | Podcast | Refactor | Regex | Security | Sharepoint | Silverlight | Smart Client Applications | Software | SQL | VB.NET | Visual Studio | W3 | WCF | WinFx | WPF | WSE | XAML | XLinq | XML | XSD