Replay- The DataView Show #14: SQL Performance Best Practices – especially for Big Data

This presentation discusses the SQL best practices that are critically important as databases get bigger and more complex. This presentation will discuss the SQL writing techniques, table cardinality, index factors, and other consideration that make your SQL run faster. You will learn through this presentation SQL best practices tuning tips, the real life issues, and agile SQL considerations for working with Spring Batch, Docker Containers and other agile tools.

This presentation was developed for application developers to help them understand high performance SQL factors for running against tables that contain billions of rows. These SQL techniques, table factors and index considerations discussed show how small critical factors can make a big performance difference against big data tables. SQL functions, UDFs, common table expressions CTE and other SQL techniques are only some of the factors that need to be considered in the SQL development cycle. This presentation will help you understand all these SQL performance factors and the best practices used to get the fastest SQL results from your biggest tables.

About our special guest:
Dave Beulke and Associates is a customer-focused and results-oriented DB2 consulting, DB2 training and education and software company specializing in overall performance for all aspects of information technology. We specialize in IBM’s DB2 database running on any platform and help companies reduce CPU demands by as much as 40%, saving our customers millions of dollars. Through focused DB2 performance consulting engagements, we have improved computing performance of systems, databases, application and SQL reducing total cost of ownership and eliminating the need to upgrade computing hardware.

Stay safe, stay healthy, wash your hands, and visit http://www.DataViewShow.com for more free education. We love subscribers and appreciate your thumbs up!

Dave Beulke, IBM GOLD Consultant and Champion
Dave Beulke, IBM GOLD Consultant and Champion

WATCH THE REPLAY

97% of our HUGE live audience learned something! What will you learn?

GET A PDF

A PDF makes great reference material, but you are cheating yourself if you don’t watch the video above! Dave elaborates key points and addresses several audience questions! Get the PDF here!

The DataView Show #4: Db2 LUW Performance Tips and Tricks by “Raghu on Tech”

Top blogger Raghu Cherukuru, aka “Raghu on Tech”, shares his best tips and tricks for analyzing and improving Db2 LUW database performance. His super helpful and very interesting blog posts can be found at www.raghu-on-tech.com – check it out!

During this show Raghu covered Db2 monitoring and tools (the free or built-in kind), monitoring with WLM, Db2 pureScale tips, Db2 DPF advice, Db2 sorting, index design, SQL tuning, and Explain plans.

Raghu Cherukuru, Sr. DBA

100% of our large studio audience learned something! What will you learn?

Watch the Replay!

The show is 1 hour and 5 minutes long – we hope you enjoy every minute of it!

Get a PDF!

We can’t always do this, but Raghu was gracious enough to allow us to make a PDF of his presentation available: CLICK HERE for PDF

Experimental – MP4 Video

CLICK HERE for link to MP4 video replay of the show. It will likely open in your browser. Alternatively, try right-clicking and save-as to download the media.