Jasona, I would go camping, as you said time with family is valuable

What do you do when business wants an on-premises "backup" just in case the cloud would vanish or become unavailable. (We would have other problems, but let start with this)

Creating...

1.

You can probably disable step 3 "Reorganize index" in this modern world, saving a lot of io/time for minimal gains

Step 4 "Update statistics" is usually sufficient to get the best...

For SSIS, there is a property "Clean logs periodically" with retention days. This probably creates an "SSIS Server Maintenance Job" sql agent job.

For maintenance plans you can create a new...

Can you refine the logic with some sample data / wanted output?

select *
from A
where not exists (select * from b where a.server=b.server and a.login=b.login )

or 

select *
from...

At first glance you use a lot of user defined functions. That makes it difficult for the SQL Server to optimize the execution as it is hidden in function logic.

Have...

Indeed, was for a different post. Your answer should work. My usual culprit is a monitoring tool

Grant probabily wrote it that way for readability

with solution as (....) /*sampledata and solution*/Select ... from solution /* verify */

*wrong post*

• This reply was modified 4 months, 3 weeks ago by Jo Pattyn. Reason: was answer for another post

There is probably a non-printable character in it.

CREATE TABLE #DIVIDENDS_NEW
(
[DIVIDEND_AMOUNT] [varchar](15) NULL
);

insert into #DIVIDENDS_NEW select NULL;
insert into #DIVIDENDS_NEW select '5';
insert into #DIVIDENDS_NEW select CHAR(10); /* invisible character*/

SELECT...

The upper part is probably status (84)

and the lower  part your history

SQL Server has to match history with status before it can filter out on statusValidFrom

It decided it would need...

The ranking function solve this as Johan mentioned

WITH SELECTIE AS 
( 
SELECT mypk ...
  ,ROW_NUMBER() over 
  ( 
  PARTITION BY column1, column2 ... /* defines the...

You may try setting up deadlock monitoring with extended events https://www.mssqltips.com/sqlservertip/5658/capturing-sql-server-deadlocks-using-extended-events/

You may adjust IndexOptimize to only maintain statistics instead of rebuilding/reorganizing indexes ( those are intensive with low gains) (*...

Sometimes SQL Servers filters very late

and it is possible to have divide by zero on rows that aren't relevant

because they are done before SQL Server decides to filter them out.

Sometimes SQL Servers filters very late

and it is possible to have divide by zero on rows that aren't relevant

because they are done before SQL Server decides to filter them out.