Skip to content

SelectDistinct.io

A tech blog about data, warehousing and analytics.

Month: September 2018

SQL | Always Reference Aliases

September 30, 2018 / Matt / Leave a comment
Always Reference An Alias
Always Reference Aliases

A common gripe I have when reviewing and maintaining other people’s SQL, aside from the obvious readability due to poor formatting, is their lack of aliases. In this post, I’d like to talk about why you should always reference aliases. The one major reason why, and the one minor reason when not to.

Continue reading →

Recent Posts

  • It’s Performance Review Time!
  • SQL | Always Reference Aliases
  • Consistency Over Standards
  • Women In Tech | Speed-Mentoring
  • Dynamic Column Names In SSRS 2005

Categories

  • Business Objects Data Services
  • DBMS
  • Dimensional Design
  • Interview Questions
  • Javascript
  • JSON
  • Python
  • Random Thoughts
  • Reporting
  • SAP
  • SQL Foo
  • SSRS
  • Window Functions

Archives

  • November 2018
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • March 2018
  • February 2018
  • December 2017
  • October 2017
  • September 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
Delivery by Matt Komyanek