DWHPro Insights

stored procedure

Understanding Teradata Load Isolation Most read

Illustration of a network graph with circular nodes joined by lines

Isolation Levels and their Impact on Performance & Concurrency Isolation is a crucial factor in determining the visibility of transaction integrity to database users. This property guarantees that concurrently executed transactions produce identical results to those executed sequentially. Nonetheless, relinquishing this requirement can enhance transaction concurrency, improving performance. However, this also implies accepting inconsistent outcomes. …

Read more

Maximize Your Teradata Compression Potential with DWHPRO TITHONIZER

Illustration of a person in a suit standing beside a database cylinder

Do you work in an environment where a Teradata compression tool is installed that conforms to your satisfaction? If not, I assume you are probably not very pleased with having to walk through the databases, table by table, to find out what to compress on which column. Typically, this is time-consuming, fatiguing, and subject to …

Read more

Benefits of Organizing Stored Procedures into Chapters and Steps

Illustration of a glossy orange database cylinder with data fragments across its surface

I made organizing Stored Procedures into Chapters and Steps a principle. These separation points are marked by comments and variables used in performance and result logging. A step refers to a technical or conceptual task that cannot be further divided without losing the abstraction of Stored Procedures or the main task. Examples of a step …

Read more

DWHPro

Expert network for enterprise data platforms. Senior consultants, project teams built for your challenge — across Teradata, Snowflake, Databricks, and more.

📍Vienna, Austria & Jacksonville, Florida

Quick Links
Services Team Teradata Book Blog Contact Us
Connect
LinkedIn → [email protected]
Newsletter

Join 4,000+ data professionals.
Weekly insights on Teradata, Snowflake & data architecture.