Toad World® Forums

How to get the Correct row Count for a table in SQL Server - TIP_002 (Updated 10-Oct-2010) [1 Attachment]


#1

How to get the Correct row Count for a table in SQL Server - TIP_002 (Updated 10-Oct-2010) [1 Attachment]


#2

[ 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

hfreeman@msn.com

678.414.0090 my cell Primary

Original email…
image001.gif


#3

[ 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

hfreeman@msn.com

678.414.0090 my cell Primary

Original email…
image002.jpeg


#4

[ 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

hfreeman@msn.com

678.414.0090 my cell Primary

Original email…
image002.jpeg