Another way to do a not exists SQL query with best performance

This comes up again and again as a thorny and persistent problem. I got this new way of doing this from my friend.

SELECT alias1.PKCol1, alias1.Col2
FROM table1 alias1
WHERE alias1.Col3= 11 AND alias1.Col4= 43 AND
      NOT EXISTS (SELECT 'x' FROM table2 alias2 WHERE alias2.PKCol1 = alias1.PKCol1)

Comments

Post a Comment

Popular posts from this blog

Enable Visual Studio to use more than 2GB of memory

Very useful when you have more memory: http://mkwec.de/2010/01/08/make-visual-studio-use-more-than-2-gig-of-memory/ "Using Visual Studio can be quite frustrating: even having a big quad processor 8 gig SSD raid machine it will still complain not being able to complete an operation because there is not enough “storage” available. Ever seen this “Not enough storage is available to complete this operation.”-Message in large solutions with many projects? Actually this “storage” means memory and you can use the following steps to provide more memory to visual studio: Windows XP users only:  add the /3GB switch to your boot.ini (make sure you backup your old boot.ini before) Windows Vista users only: from the Visual Studio command prompt run: BCEDIT /Set IncreaseUserVa 3072 Apply large address awareness to visual studio by running: editbin /LARGEADDRESSAWARE devenv.exe in your <path-to-VS>/Common7/IDE (make sure you backup your old devenv.exe) Reboot Now Visual Stu...
Read more

Firefox and Chrome dark mode

I found many bad links about how to get dark mode in Firefox. The best way to make Firefox itself dark, is to open developer tools > hit the gear button and select the dark theme. To increase the font size within, just press Ctrl and "+" button. The Ctrl method increases the font size in Chrome as well. If you want to get a dark mode chrome,  click on the ... (vertical) at top right corner of the developer tools >  settings > Theme: Dark.
Read more

Dealing with the morons who built Dell 7710 and RAID

There is no clear documentation available online, so here goes: - the cryptic device configuration option in the boot options is where you configure RAID. - the morons who developed UEFI screwed all of us. If you have a full system image backup of lousy windows 10 - to restore that piece of steaming bullshit, your USB drive should be formatted for UEFI. Otherwise windows booted from a regular USB drive will whine that UEFI is not available. - trying to add a option via the bios does not work Lastly, to get the lousy RAID drivers to be able to install windows 10 on fresh drives, download the intel storage drivers from the Dell support website for the 7710. It will not say RAID anywhere, but if you download it and extract the contents to a USB drive, on recovery, when it asks for the driver, select one of the system information files and your raid drive will be visible now. Thank you Dell support for not doing your job and not mentioning this information anywhere in a way humans ...
Read more