Viewing 15 posts - 16 through 30 (of 319 total)
Your clustered index is fine.
May 17, 2018 at 10:49 am
May 17, 2018 at 9:00 am
May 17, 2018 at 8:44 am
May 17, 2018 at 8:20 am
May 17, 2018 at 7:33 am
;WITH DS ASMay 17, 2018 at 7:31 am
May 17, 2018 at 6:43 am
The idea to join these two lookups is interesting indeed.
I don't think it will help in this immediate problem but it's certainly something I should do.
May 17, 2018 at 6:22 am
I tried but did not succeed...
my traces are going to a folder Z:\SQLTraces
I disabled inheritance on the folder |:\SQLTraces, then set the permission on it to everyone...
May 3, 2018 at 10:24 am
The extended events file gives me a lot of MEMORY_ALLOCATION_EXT and some SOS_SCHEDULER_YIELD
Is it possible to aggregate those numbers to get some idea.
As you may guess, I...
August 10, 2017 at 2:08 am
August 9, 2017 at 3:29 pm
Yes, of course, we'll try to cleanup regularly but... better be safe!
Thanks
August 9, 2017 at 10:04 am
Ok, will do.
It was my understanding too that Insert should be blisteringly fast... and I need it to improve some speed issue I have with existing stored procedures.
August 9, 2017 at 6:46 am
Fair point... so I tried to read back as well
Now, the Insert into the InMemory table is sometimes a faster but the read is a lot slower!
I...
August 9, 2017 at 5:23 am
July 4, 2017 at 4:47 am
Viewing 15 posts - 16 through 30 (of 319 total)