For T-SQL Tuesday I write about my mentor Vinod Kumar and his interesting question, which leads to a disabled index, its index levels and the B-Tree.
SQL SERVER – Soft Delete Conversation – Your Opinion Needed
My soft delete post got great replies on both sides. Here are short abstracts from readers like Karen Lopez and Tyler Clendenin, and your input is welcome.
SQL SERVER – Find Automatically Created Statistics – T-SQL
Ad-hoc queries on a production server left many useless automatically created statistics. Here is a T-SQL script to find them so you can clean them up.
SQL SERVER – Index Created on View not Used Often – Limitation of the View 3
An Index Created on a view does not always stop queries from reading the base table. Limitation 3 of views, shown with a simple example.
SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script
A simple script to retrieve the plan cache for one query and remove just that plan, instead of clearing the whole cache on a busy server.
Spatial Indexes: Speeding Up Distance Searches
Use spatial indexes for geography distance searches, compare actual plans and reads, and inspect tessellation with built-in diagnostics.
SQL SERVER – Computed Columns – Index and Performance
The last article in my series on computed columns looks at index and performance, with a summary of every earlier part on storage and PERSISTED columns.