#sqltwitter search results
#SQLTwitter, which is faster select b.destinationkey from a join b on a.thirdkey=b.thirdkey where a.sourcekey="value" 20000 times or select a.sourcekey,b.destinationkey from a join b on a.thirdkey=b.thirdkey where a.sourcekey in (..list 20000 keys...) (in mysql)?
This was perhaps more crude and specific to #SQLtwitter than I had anticipated
RT +1 .. but coping via #sqltwitter :) @onpnt: who else is going through #sqlpass withdrawals?
#SQL question: Why do we have this syntax order [expression] AS [alias] for renaming tables and columns, but for common table expressions, we have this syntax order WITH [alias] AS [expression] ? 🧐 #SQLtwitter #SQLx
that session at TugaIT lead to me speaking a few more times - at TugaIT, SQLSaturdays. For me personally, i’m grateful for how it kickstarted deeper involvement in #sqlfamily, #sqltwitter, and was the start of some great lasting friendships :-)
That is one of the first rules of #SQLTwitter... Don't mess with @IrishSQL
That is one of the first rules of #SQLTwitter... Don't mess with @IrishSQL
#SQL question: Why do we have this syntax order [expression] AS [alias] for renaming tables and columns, but for common table expressions, we have this syntax order WITH [alias] AS [expression] ? 🧐 #SQLtwitter #SQLx
that session at TugaIT lead to me speaking a few more times - at TugaIT, SQLSaturdays. For me personally, i’m grateful for how it kickstarted deeper involvement in #sqlfamily, #sqltwitter, and was the start of some great lasting friendships :-)
This was perhaps more crude and specific to #SQLtwitter than I had anticipated
#SQLTwitter, which is faster select b.destinationkey from a join b on a.thirdkey=b.thirdkey where a.sourcekey="value" 20000 times or select a.sourcekey,b.destinationkey from a join b on a.thirdkey=b.thirdkey where a.sourcekey in (..list 20000 keys...) (in mysql)?
RT +1 .. but coping via #sqltwitter :) @onpnt: who else is going through #sqlpass withdrawals?
Something went wrong.
Something went wrong.
United States Trends
- 1. Good Monday 23.3K posts
- 2. Steelers 53.5K posts
- 3. #ITZY_TUNNELVISION 31.7K posts
- 4. Mr. 4 4,736 posts
- 5. #MondayMotivation 28.9K posts
- 6. Rudy Giuliani 13.3K posts
- 7. Resign 115K posts
- 8. Chargers 38.6K posts
- 9. Schumer 235K posts
- 10. #Talus_Labs N/A
- 11. Tomlin 8,404 posts
- 12. Rodgers 21.6K posts
- 13. 8 Democrats 10.6K posts
- 14. Happy Birthday Marines 3,211 posts
- 15. Tim Kaine 23.2K posts
- 16. Sonix 1,427 posts
- 17. Voltaire 9,212 posts
- 18. Angus King 19.1K posts
- 19. #BoltUp 3,134 posts
- 20. The BBC 404K posts