SQL is the universal database language and one of the most important parts of a data scientists toolkit. Explore Tips, tricks and more for writing better faster SQL
Write a lot of SQL joins? Learn the magic of the Apply operator to make more efficient and performant joins between tables and datasets. Using Apply can often outperform joins or subqueries and makes your code much cleaner and easier to read.
In this article we’ll show you five little-known SQL Server Management Studio tips and tricks that even veteran SQL coders may not be aware of. By learning these shortcuts you can massively improve your SQL speed and efficiency, and its a fun way to impress your coworkers. (If you’re new or just want to try…