Tuning the Snowflake Data Cloud
Optimizing Your Data Platform to Minimize Cost and Maximize Performance
Chapter
Write a program that defines a function of type void called printMessage(). The function outputs a simple message on the standard output. Call the user-defined function from the main function: ...
Chapter
In this chapter, we will learn about the built-in types in C and variable declarations.
Chapter
Text here…
Book
Optimizing Your Data Platform to Minimize Cost and Maximize Performance
Chapter
Query optimizers reduce the cost of queries while retaining the original intended functionality. Furthermore, query optimization seeks to reduce the volume of data accessed, further reducing costs.
Chapter
The <time.h> header declares functions that allow us to work with date-time. This chapter explains how to obtain and format the current time and date.
Chapter
A union is a user-defined type whose members overlap in memory. Unlike a structure whose members occupy separate regions of memory, the union’s members all occupy the same memory region. The size of the union ...
Chapter
Enumerations are types whose values are symbolic names. These names have underlying integral values. To declare an enumeration type, we use the following syntax: enum MyEnumName { S...
Chapter
Security is critical in any application with access to live information – even public information. Security means controlling access to features and information; unless Annie is specifically granted access to ...
Chapter
Operators are an essential part of the language. This chapter explains what they are and how they are used. It might seem that there is plenty of theory surrounding this subject but do not worry. We need to ad...
Chapter
You may recall from previous chapters that I discussed micro-partition pruning, but I did not explain what micro-partitions are, as they deserve a chapter of their own. This is that chapter.
Chapter
The typedef declaration creates a synonym for the existing type. We use the typedef to create an alias name for the existing type name. The usage is of the following syntax: typedef...
Chapter
Write a program that defines a simple structure called Person. The structure has the char*, int, and double fields. Declare a variable of this structure type inside the main and assign values to each member field...
Chapter
By now, we’ve read about Spring and dependency injection, along with topics like web services (particularly REST services), transaction, persistence, and security. These are likely to be the "most important" p...
Chapter
This chapter explains statements in general – expressions ending with a semicolon (;) and statements built into the language itself.
Chapter
Virtual data warehouses, also called multicluster compute, are a first-order named object for a group (or cluster) of servers with multicore/hyperthreading CPU(s), memory, and temporary storage (SSD). Warehouses ...
Chapter
Write a program that defines, uses, and then undefines a macro. The macro names and their contents are arbitrary: #include <stdio.h> // define the macro ...
Chapter
What is an array? An array is one or more data objects of the same type positioned next to each other in memory. Once declared, the array size is fixed; we cannot add nor remove elements to and from the array....
Chapter
This chapter shows different coding examples, emphasizing the importance of moderate examples in the learning curve of JavaScript development. It highlights how these examples serve as a critical bridge betwee...
Chapter
This chapter marks a change of focus for the remainder of this book as we will now look to solving real-world performance issues. My experience is derived from develo** and implementing pragmatic solutions t...