A recap of this case of redundant indexes, from Jon and Mike’s basics to the demos where redundant indexes are useful with small and large result sets.
SQL SERVER – Send Email From SQL Server – Configure Database Mail – SQL in Sixty Seconds #039 – Video
SQL Server is not mass mailing software, but it does need to send job alerts. This video shows how to configure Database Mail and send email quickly.
SQL SERVER – Introduction of Showplan Warning
SQL Server can be your performance tuning teacher. Vinod Kumar explains the Showplan Warning in execution plans and what each warning is telling you.
CONTEXT_INFO: Passing a Value Through a Session
CONTEXT_INFO lets you attach a small value to a session and read it anywhere in that session, even inside a trigger. This post tests SET CONTEXT_INFO on SQL Server 2025, uses it to log who changed a price, and compares it with SESSION_CONTEXT.
Making SSIS Packages Faster
Make SSIS packages faster by measuring each flow, using fast load, sizing buffers from row width, and replacing row-by-row work.
SQLCMD Mode in SSMS: Variables, :CONNECT and :r Includes
Use SQLCMD mode in SSMS for server and database variables, :CONNECT, :r include files, and an error-stop release script.
SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 Part 3
Index on Col1, Col2 and index on Col1, Col2, Col3 Part 3: Jon and Mike ask if it is always best practice to drop redundant indexes. Here is a special case.