InfoTechTarget and Informa Tech's Digital Businesses Combine.

Together, we power an unparalleled network of 220+ online properties covering 10,000+ granular topics, serving an audience of 50+ million professionals with original, objective content from trusted sources. We help you gain critical insights and make more informed decisions across your business priorities.

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

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.
OpenText™ Vertica™

OpenText™ Vertica™

38219 subscribers166 talks
Powering the World’s Leading Data Disruptors
OpenText has completed the purchase of Micro Focus, including Vertica. Our combined expertise expands our analytics offerings to help customers confidently scale analytics to the largest and most demanding workloads for the fastest predictive insights available on the market.
Related topics