This is a word search for most (but not all) of the hints available in T-SQL.

Heaps, Deletes, and Optimistic Isolation Levels

by Additional Articles

Brent Ozar Blog

Heaps

Erik shows that heaps have even more drawbacks under optimistic concurrency.

Influence the Program

by Steve Jones

SQLServerCentral.com

Editorial

You have the opportunity to influence the makeup of the conference agenda for the PASS Summit

SSIS Package with a Derived Column

by Thomas Stricker

SQLServerCentral.com

Derived Columns

I created this article to demonstrate the use of derived columns inside a ForEachLoop Container for a client requirement for some auxiliary marketing reports. I found the Data Conversion tool useful to escape the problem of mismatched data types, which is an issue with versions of Microsoft SSIS.

Building a Custom Blocked Process Report

by Additional Articles

SimpleTalk

Monitoring

Blocking in SQL Server is normal behavior, but excessive blocking can lead to many complaints and is a symptom of poor performance. SQL Server contains a vast amount of information that can help when troubleshooting performance issues like blocking, but understanding and gathering that information when you need it is a lot of work. Darko Martinovic explains his solution for a custom blocking report.

Configure Read Only Routing

by Ganapathi varma Chekuri

SQLServerCentral.com

always on

The advantage of Setting the readable secondary as Read-Intent Only will allow the secondary server to serve the read-only workload only if the connection string of the application contains Application Intent=Readonly parameter.