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

Something like this http://www.sqlservercentral.com/scripts/String/89388/

Do they have to go into the same DB?

Could you not use union and 3 part naming convention

eg

select ... from ProdDB.ProdSchema.ProdTable

union

select ... from ArchiveDB.ArchiveSchema.ArchiveTable

Other methods would be to SSIS the...

Take a look at Perry's stairway for always on, it goes from the OS cluster setup upwards and will detail steps needed to create the WSFC and enable AlwaysOn