Monthly Archives: June 2019

Adaptive Joins SQL 2017

By | June 20, 2019

  select a.StateName , a.CityName , sum(flights) from Airports a inner join normalization_index n on a.AirportSeqId = n.OriginAirportSeqID where a.AirportSeqId > 1474703 group by a.StateName , a.CityName     select a.StateName , a.CityName , sum(flights) from Airports a inner join normalization_index n on a.AirportSeqId = n.OriginAirportSeqID where a.AirportSeqId=1451202 group by a.StateName , a.CityName    … Read More »

94% Compression???? SQL Server from 1GB to 65 MB

By | June 11, 2019

In this video we go about taking data that is little over 1 GB in size and incrementally reducing its size all the way down to 65MB. This is mostly to highlight that good design can significantly reduce the memory footprint of the data. With tools like PowerbI etc. the push is towards storing the… Read More »