I have two tables with identically named, typed, and indexed key columns. One of the them has a unique clustered index, the other one has a non-unique.
The test setup
Setup script, including some realistic statistics:
DROP TABLE IF EXISTS #left;
DROP TABLE IF EXISTS #right;
CREATE TABLE #left...
After asking and Trying out different options , the issue was really simple ,I just had to reboot the server ,when the server was back up I tried to login with the account that is in the AD group ,it logged in successfully .(I feel a bit embarrassed)
0
I recently read this article https://eng.uber.com/mysql-migration/ which explained that Postgresql does not actually delete tuples (rows) when a change is made, but simply keeps it and adds canonical data to make sure it always pulls the newest version of the data.
GDPR requires that users can d...
Can I eliminate the sort without changing the query (which is vendor code, so I'd really rather not...). I can change the table and indexes.
If you can change the indexes, then changing the order of the index on #right to match the order of the filters in the join removes the sort (for me):
...
I see in this post on listagg — Rows to Delimited Strings talking about SQL's LISTAGG() clause ON OVERFLOW
The return type of listagg is either varchar or clob with an implementation defined length limit.
I've never previously seen the term clob before. Looking it up, it's apparently a term...
