SELECT * FROM A
WHERE
EXISTS (SELECT * FROM B)
AND
EXISTS (SELECT * FROM C)

Selects all rows from table...

I was just asked for a job. And was asked if I could help with an overview of some info. Told how I would solve the problem with a simple...

Thanks all, I'll give this a go tomorrow.
I used an auxiliary calendar and picked up all combinations of days of the 28 of February and the 1st of march.
This would...

Is 2014 similar to 1990 because Germany won the FIFA World Cup both years?
Yeah that is ok, your choice.

More obvious would be: Dates fall om the same...

What is the size of the index ?
How many rows are in each index page ? (Average).

For Clustered indexes there are some 'methods' to obtain the position...

--
-- Convert dd/mm/yyyy to a datetime format independend of regional and language settings.
--
declare @datestring varchar(200) = '24/01/2019'
select      substring(@datestring,7,4)+substring(@datestring,4,2)+substring(@datestring,1,2)
select CONVERT(datetime,substring(@datestring,7,4)+substring(@datestring,4,2)+substring(@datestring,1,2))


When sure that...

This looks like the same problem :

https://social.technet.microsoft.com/Forums/WINDOWS/en-US/b4420367-381f-45e5-a5cb-8fd1fb29cbc0/ssms-2016-1641-slow-response-on-object-explorer?forum=sqltools

No solutions, but some workarounds are suggested there,
Ben

Here an extended version of  Alan Burstein's example.

A End station is added.
So roundtrips can be handled distinctly.
More examples are added to show the build in increments.

Thank you,
Simple, elegant and I have learned something.🙂🙂🙂
Thanks,
Ben

One other thing to consider is the table in relation to other tables.

If the table lives in isolation, then you can make the choice purely based on that...

Suggestion:

Make an Auxilary table 'Calendar' and use that table to determine the number of days in a period, or between two dates.
In the Auxilary table each day...