In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.
2017-04-24
3,438 reads
By damianwidera
Good morning! It was a tough weekend as we supposed to be in Goteborg...
By Steve Jones
Not something you’ll do too often, but you might find yourself doing this if...
By James-Serra
With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used...
Comments posted to this topic are about the item Is Data the Future of...
Comments posted to this topic are about the item “Included columns” for non-clustered indexes...
Comments posted to this topic are about the item Reindexing a database
Ask SSC