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