From Seven Days to 30 Seconds – Microsoft SQL Server Reports Fly Fast on Vertica

Logo
Presented by

Joy King, VP Vertica and CB Bohn, Principal Data Engineer Vertica

About this talk

In our next Under the Hood Webcast, hear Chris “CB” Bohn, database engineer expert who recently joined Micro Focus to build out its corporate data warehouse on Vertica. Learn how has CB migrated legacy queries from Microsoft SQL Server to Vertica, specifically one report that took seven days to complete. CB rewrote 2,500 lines of T-SQL code using Vertica’s analytical window partitioning, shrinking the code down to 150 lines as a one-pass query. The report now runs in 30 seconds! If you are looking to modernize your data warehouse in record time with faster analytical performance and learn important tips and tricks from a Vertica database expert, then you won’t want to miss this Webcast.

Related topics:

More from this channel

Upcoming talks (2)
On-demand talks (158)
Subscribers (36600)
The Vertica Unified Analytics Platform is built to handle the most demanding analytic use cases and is trusted by thousands of leading data-driven enterprises around the world, including Etsy, Bank of America, Uber, and more. Based on a massively scalable architecture with a broad set of analytical functions spanning event and time series, pattern matching, geospatial, and built-in machine learning capability, Vertica enables data analytics teams to easily apply these powerful functions to large and demanding analytical workloads. Vertica unites the major public clouds and on-premises data centers, as needed, and integrates data in cloud object storage and HDFS without forcing any data movement. Available as a SaaS option, or as a customer-managed system, Vertica helps teams combine growing data siloes for a more complete view of available data. Vertica features separation of compute and storage, so teams can spin up storage and compute resources as needed, then spin down afterwards to reduce costs.