I'd suggest you take a look at the Minion tools. They have a great deal more flexibility and management than Ola's scripts. I'm not knocking Ola's scripts, they...

Yeah that could do it fine too. It will likely block the table for a time (depending).

To keep the table from being accessed, well, it really depends a lot on your system, the configuration etc. If you do not have SA or DBO for all your...

Try switching to PowerShell.

How do you identify a return trip of the second address is different? You didn't mention it, but do you also have a RiderID or something along those lines? Otherwise,...

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...