Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: What are your five most common T-SQL commands

    Here are mine

    sp_help 'tablename'

    sp_spaceused 'tablename'

    select si.name, si.is_disabled, iu.* from sys.dm_db_index_usage_stats iu join sys.indexes si on iu.object_id = si.object_id and iu.index_id = si.index_id where iu.object_id = object_id ('tablename')

    dbcc show_statistics ('tablename','indexname')

    dbcc sqlperf(logspace)

Viewing post 1 (of 1 total)