SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Identifying Columns to Create Index via T-SQL

To identify columns on which you need to create indexes for fine tuning query performances you can run the T-SQL statement below; SELECT OBJECT_NAME(OBJECT_ID), mid.included_columns, mid.statement, mic.column_name, mid.equality_columns, mid.inequality_columns, mic.column_usage FROM sys.dm_db_missing_index_details mid CROSS apply sys.dm_db_missing_index_columns(mid.index_handle) mic ORDER BY mid.index_handle … Continue reading

Coffee and SQL

I’m Carla Abanes, working as a full time Senior SQL Database Administrator here in Singapore for an established financial trading firm.


Leave a comment on the original post [coffeeandsql.com, opens in a new window]

Loading comments...