Collecting SQL Server performance counter data for trending

Collecting SQL Server performance counter data for trending

Index - sp_helpindex2 to show include columns

Kimberly L. Tripp | sp_helpindex2 to show included columns (2005+) and filtered indexes (2008) which are not shown by sp_helpindex

Determine SQL Server memory use by database and object

Determine SQL Server memory use by database and object

indexing - List of all index & index columns in SQL Server DB - Stack Overflow

indexing - List of all index & index columns in SQL Server DB - Stack Overflow


--select * from sys.indexes
--select * From sys.index_columns

select
ind.name, ind.index_id, ic.index_column_id, col.name as indexname, t.name as tablename,
ind.*, ic.*, col.*
from
sys.indexes ind
inner join
sys.index_columns ic on
ind.object_id = ic.object_id and ind.index_id = ic.index_id
inner join
sys.columns col on
ic.object_id = col.object_id and ic.column_id = col.column_id
inner join
sys.tables t on
ind.object_id = t.object_id
where
ind.is_primary_key = 0
and ind.is_unique = 0
and ind.is_unique_constraint = 0
and t.is_ms_shipped = 0
and col.name = 'status_id'
and t.name = 'user_lo'
order by
t.name, ind.name, ind.index_id, ic.index_column_id

Performance Implications of Parameterized Queries

Performance Implications of Parameterized Queries

Dynamic Management Objects - SQLServerPedia

Dynamic Management Objects - SQLServerPedia

DM Objects - Sys.dm exec query stats - SQLServerPedia

DM Objects - Sys.dm exec query stats - SQLServerPedia

ORDER BY Clause Enhancement and Pagination in SQL Server 2011

Microsoft SQL Server Developers group Group News | LinkedIn

Find SQL Server data and log files that are almost out of space

Find SQL Server data and log files that are almost out of space

Creating I/O performance snapshots to find performance problems in SQL Server

Creating I/O performance snapshots to find performance problems in SQL Server