An index rebuilding limit can control lock waiting or a resumable execution interval. I decide which behavior the maintenance window needs.
Parse and Compile Time: Reading the First Line of STATISTICS TIME
Someone pastes a compile time of 24 ms and asks if the server is slow. Run it twice and watch the plan cache do its job.
SQL SERVER – How to Enable Lock Pages in Memory?
Recently I received an email from user that he tried to search for solution on SQLAuthority.com for how to enable lock pages in memory but could not find a solution for it.
Grouping by query_hash to Find Cheap Queries That Cost the Most
Group cached statements by query_hash to find high total CPU and reads, compare plan hashes, and account for missing cache history.
Finding Which Indexes Use a Custom Fill Factor Setting
Find indexes with a custom fill factor, compare their page counts, and review one rebuild without changing the server-wide setting.
SQL SERVER – sp_readrequest – Long Running Process
sp_readrequest kept showing up as a long running procedure. It is Database Mail waiting on its queue with a 600 second timeout, usually nothing to worry about.
Temporal History Queries: Indexing the History Table for Speed
Your current table is tiny, but the AS OF question hides in the history table. See the reads before and after a key-first index, and what it costs.