Windows functions / CTE: ease of querying

Extended events for finding specific occurences

Query Store: what queries are likely the culprit

SSRS / SSAS albeit getting outdated

Read committed snapshot isolation: similar like Oracle,...

Wow, luckily you got that camping trip

Most run on standard edition, only BI has enterprise due bundle with powerbi report server

Hmm, the newletters url's point to the same article of Koen

Post with links to those articles got automatically removed

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