jokershigh

When clicking anywhere inside the THtmlViewer component (specifically on elements that aren't interactive links or controls handled differently), the THtmlViewer.HTMLMouseDown event handler is triggered. This handler unconditionally calls SetFocus;, causing...

CTE retuns empty instantly, but applying where to the empty set in the main query is slow

6

In the query below, the CTE returns empty instantly. The full query returns, that just filter the empty result, takes 3s, If I remove the where clause, it also returns...