How to get the Correct row Count for a table in SQL Server - TIP_002 (Updated 10-Oct-2010) [1 Attachment]
[ Attachment(s) from Hank Freeman included below]
Ref: Script à SCRIPT_Table_Size_Info(2000-2008)10-Oct-2010(FINAL).sql.
This script has just been updated because it was determined that it was not
returning all the tables names because declared variables within were not the
big enough to receive all the table name information … Additionally the
‘Timestamp_Str’ was rewritten with a CAST statement, which is better
programming. See update notes in the script.
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
Original email…
[ Attachment(s) from Hank Freeman included below]
Ref: Script à SCRIPT_Table_Size_Info(2000-2008)10-Oct-2010(FINAL).sql.
This script has just been updated because it was determined that it was not
returning all the tables names because declared variables within were not the
big enough to receive all the table name information … Additionally the
‘Timestamp_Str’ was rewritten with a CAST statement, which is better
programming. See update notes in the script.
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
Original email…
[ Attachment(s) from Hank Freeman included below]
Ref: Script à SCRIPT_Table_Size_Info(2000-2008)10-Oct-2010(FINAL).sql.
This script has just been updated because it was determined that it was not
returning all the tables names because declared variables within were not the
big enough to receive all the table name information … Additionally the
‘Timestamp_Str’ was rewritten with a CAST statement, which is better
programming. See update notes in the script.
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
Original email…