Viewing 15 posts - 2,281 through 2,295 (of 2,645 total)
August 20, 2018 at 10:08 am
Firstly this doesn't look like a CROSS JOIN is needed. I think the query would produce the same results with an INNER JOIN:SELECT *
FROM table_B
INNER...
August 20, 2018 at 5:59 am
August 19, 2018 at 3:09 pm
August 19, 2018 at 1:59 pm
August 19, 2018 at 1:08 pm
August 19, 2018 at 4:58 am
Jeff Moden - Friday, August 17, 2018 6:11 PMSooooo..... SOS actually DOES stand for what I thought. 😀
It's a new thing, I...
August 17, 2018 at 7:46 pm
August 17, 2018 at 9:45 am
August 17, 2018 at 8:35 am
August 17, 2018 at 8:07 am
August 17, 2018 at 8:03 am
You can do it in batches so it won't affect other processes:
CREATE INDEX IX_DUMP_JUL2018_1 ON [DUMP_JUL2018] (AGRNO,[VFLAG])
CREATE INDEX IX_SPOOL_1 ON [SPOOL] (AGRNO)
GO
DECLARE @ROWCOUNT...
August 16, 2018 at 4:42 am
August 15, 2018 at 9:49 am
Viewing 15 posts - 2,281 through 2,295 (of 2,645 total)