RSS

Daily Archives: April 24, 2013

Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS

Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS

A problem I face often is not knowing the size of a new table that I’m creating. I put some basic code together that pulls the column information from INFORMATION_SCHEMA.COLUMNS and with some basic math gets the approximate size of the table based on the estimated number of rows.

Read the rest of this entry »

Advertisements
 

Tags: , , , , ,

 
%d bloggers like this: