In this article, we will describe the most popular methods that DW engineers use today to solve SQL performance problems, based on our real-world experience. We will point out the pros and cons of each method, as well as describe the basic tools/commands for using each one, and provide some best-practice recommendations. The intended audience is DW support engineers, DW developers, and DBAs. The methods presented are not DW-specific and pertain to SQL tuning in general, so this article will be useful to a broader audience of database professionals with interest in SQL tuning and not only to Data Warehouse professionals..
Congratulations to the 2021 ODTUG Officers Congratulations to the newly elected officers of the ODTUG Board of Directors! One of the things that sets ODTUG apart is the dedication of our volunteers a...
ODTUG would not be the organization it is without all our amazing volunteers! First, we would like to thank everyone who has given their time and dedication to making each of our communities one of a ...
2601 Iron Gate Drive, Suite 101
Wilmington, NC 28412