Grant probabily wrote it that way for readability

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

*wrong post*

• This reply was modified 3 months, 2 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.

Now it's in a novel/comic format, I might read it

Currently using Veeam. It has a short I/O freeze when it backups when VSS writer orders SQL to pause for a few seconds.

It makes it easier for the sysadmins in...

Congratulations!

We have a hybrid approach. I prefer working at the office, but I only have a commute of 15 minutes and my home isn't really setup for remote work.

Many work...

We began switching to c# scripts in SSIS to parse the excel and output the required columns

As SSIS get a litte love lately, thinking of moving to c#, powershell. We don't have very complicated workloads and excel is being read by a c# script inside SSIS

Thanks for sharing