Just practice practice practice with the T-SQL language.

I would recommend the 70-461 official training guide

Measure up test exams

The following stairways

http://www.sqlservercentral.com/stairway/119892/

http://www.sqlservercentral.com/stairway/75773/

http://www.sqlservercentral.com/stairway/104497/

Check the exit commands of the job steps.

Is the last one's on success action, quit job reporting failure by any chance?

Debaser

Pixels

set @sql = 'datepart(year,''' + convert(varchar(10),@BaseYrBegin,103) + '''' + ')'

Your converting the @sql into a smalldatetime, you need to convert the @BaseYrBegin to a string so that your concatenating strings,...

Members of sysadmin get their default schema overridden by whatever is set at the user mapping level to DBO.

The value of DEFAULT_SCHEMA is ignored if the user is a member...

Probably best asking that on a share point forum.

But from what I can tell as long as you have SQL 2014 with the May CU or above installed you should...

Overbeck

Whats the page_count value for the table in question.

Generally MS recommends only rebuilding indexes on tables with a page_count > 1000

While I agree with you that it should be seamless to the apps, as we are unfortunately not the custodians of the product we can't we just go and change...

There are 38920 unique units, with 16117910 rows in total in the cache table.

The schema is a 3rd party schema so changing it is going to be months of work...

You have 22GB to play with, generally I now leave around 10% for the OS, so that eats 7GB out of your allowance, so you have 15GB to play with.

I...

You could go very specific to the byte level

Values <=100 are defined as percentages

Values > 100 are defined as a fixed amounts in bytes

So if you ideally wanted to limit...

Yeah but they want it via the GUI not via script.

The only way I know to get the SQL Agent to show up in SSMS is to be part of...

They already have that, the problem is that the roles allow you to create jobs, this goes against the auditing practises the client has in place where only sysadmins should...