sys.dm_db_index_physical_stats Archives

sys.dm_db_index_physical_stats – Day 1 – One DMV a day

September 18, 2014July 3, 2020 - by Manohar Punna - 5 Comments.

Hello Geeks and welcome to the first day of the long series to come in One DMV a day. In this series of blogs I will be exploring and explaining the …

SQL Server / SQL Server Accidental DBA Series

Re indexing database tables in SQL Server

April 14, 2014December 23, 2019 - by SQL Geek - Leave a Comment

Re indexing database tables in SQL server is a very wide topic. Ideally, we have database maintenance tasks scheduled to run during maintenance window to rebuild indexes along with other maintenance …