I'm currently working on a particular table that is about 7 million records. Size on disk is about 2GB. It so happens that the way this is indexed, The size of the index is about double the size of ...
This SQL script provides a detailed view of index allocation, filegroup usage, and physical storage for user tables in any SQL Server database. It's a valuable tool for DBAs and data engineers aiming ...
I know in Oracle you can use DBA_TAB_COLUMNS (or ALL_TAB_COLUMNS). My SQL Server knowledge is very rusty, but can't you use the INFORMATION_SCHEMA.COLUMNS view?
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback