Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.
2018-03-09 (first published: 2016-02-15)
8,022 reads
Get total access,updates, rowlocks,pagelocks, stats date,rowcount for all tables or specific table by partition
2016-02-04 (first published: 2016-01-22)
879 reads
What I thought was a strange filtered index problem but turned out to be a DB settings problem
2018-05-11 (first published: 2015-08-26)
5,110 reads
get user table indexes, size and column order
2015-10-08 (first published: 2015-07-02)
1,087 reads