Filegroup Restoring and Join Elimination
This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.
2017-08-10
960 reads
This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.
2017-08-10
960 reads
After some additional testing, it looks like query 1 is correct:select s.suiteid, s.buildingid, s.SuiteName, b.buildingnumber, g.suitename, g.buildingID from suites s inner join buildings b on s.buildingid=b.buildingid LEFT JOIN RealmStageSuites g on g.buildingid=b.buildingnumber AND g.suitename=s.suitename WHERE g.suitename IS NULL AND g.buildingID is NULLAnyone know what's wrong with Q2?
2005-02-04
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers