SSMS – SQL Server Management Studio

SSRS – SQL Server Reporting Services

SSAS – SQL Server Analysis Services

PARAMETER SNIFFING – the first evocation of a stored procedure will teach the engine about the expected inputs and outcomes.  This may create an execution plan that will not be optimal for other inputs and their outputs.

PREDICATE – selection criteria in a select, update, delete query