#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. Steelers 52.6K posts
- 2. Rodgers 21.2K posts
- 3. Chargers 37.6K posts
- 4. Tomlin 8,309 posts
- 5. Schumer 225K posts
- 6. Resign 107K posts
- 7. #BoltUp 3,026 posts
- 8. Tim Kaine 19.8K posts
- 9. #TalusLabs N/A
- 10. Sonix N/A
- 11. Keenan Allen 4,979 posts
- 12. #ITWelcomeToDerry 4,742 posts
- 13. #HereWeGo 5,701 posts
- 14. Dick Durbin 12.8K posts
- 15. #RHOP 6,984 posts
- 16. 8 Dems 7,249 posts
- 17. Angus King 16.7K posts
- 18. 8 Democrats 9,311 posts
- 19. Gavin Brindley N/A
- 20. Herbert 11.9K posts