The old school definition of the term is "Search Argument Able", shortened to Sargeable. Gail's definition of the function of the term, as usual, is spot on.

I agree with Hugo. Junior IT folk are not required to know about stuff like this. A mid to senior level DBA, responsible, one assumes, for implementing, validating and verifying...

What about creating a role, grant execution to the role, assign the users to the role. You manage security for the procs only with the role. You manage user permissions...

Actually neither of those queries are parameterized. Those are local variables. They work differently than parameters. To test this as parameterized queries you'd need to either put them into a...

Pure speculation and more than a couple of assumptions... The chance for a page split is higher when updating the wider table, so over time, accumulated, the update cost is...

It could be badly written queries. It could be out of date statistics leading to poor execution plans. It could be incorrectly configured indexes. It could be....