Topics ›
Topic>sql
47 tutorials tagged with Topic>sql.
Use Index-Based Cell Access
Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.
Create a Dimension Graphical Calculation View (XS Advanced)
Create a graphical calculation view with a dimension data type.
Using Index Based Cell Access
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
Parallel Processing and Parameters
Leveraging SQLScript in stored procedures, user-defined functions, and user-defined libraries.
Intermediate Table Variables
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
Debugging Stored Procedures
Leveraging SQLScript in stored procedures, user-defined functions, and user-defined libraries.
Creating Table User Defined Functions
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
Create Stored Procedures
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
Create Scalar User Defined Functions
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
Anonymous Blocks
Leveraging SQLScript in stored procedures, user-defined functions, and user-defined libraries.
View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
Create and use a SQL view to query data from both in-memory and Dynamic Tiering tables.
Selectively Move Data Between In-Memory and Extended Tables
Move data between in-memory and extended tables. Set connection property values.
Migrate Records in Related Tables Using Stored Procedure
Using a stored procedure to migrate records in related tables as a single transaction.
Create Tables and Import Data
Create in-memory column store and Dynamic Tiering tables. Import data into both types of tables.
Create Extended Storage
Create extended storage for Dynamic Tiering.
Create a New User and Assign Permissions
Create a new `TCPH` user as well as assign roles and privileges to the new user.
Converting Between an In-Memory Table and an Extended Table
Convert an in-memory column store table to an extended table and vice versa.
Visualize a Graphical Query Plan
Generate and compare query plan for in-memory and extended tables.
Table Statistics and its Effect on Query Plans
Create table statistics. Analyze impact of statistics on query plans.
Detailed Query Plan and Indexes
Generate and access a detailed html query plan. Create indexes on columns.
Compare Prepared and Executed Plan
Generate and compare Prepared and Executed plans.
Multi-Store Tables
Create Multi-Store Tables
Initializing Database Backup and Recovery
Setting up backup and recovery for Dynamic Tiering.
Stopping and Restarting the Extended Storage Service
Occasionally you will need to stop your extended storage service. One case where this will be required is when you change a configuration parameter, you will …
Monitoring SAP HANA Using SAP HANA Cockpit and SAP HANA Studio for SAP HANA Dynamic Tiering
Checking the esserver process and coordinator types to determine if Dynamic Tiering is running and if extended storage is created and running.
Creating and Removing Extended Storage
Creating and removing Extended Storage using SAP HANA Studio and SAP HANA Cockpit
Additional checks in SAP HANA Cockpit and SAP HANA Studio
Performing additional checks for SAP HANA
Enlarging a Dbspace File Using Reserved Space
Use reserved spaces to increase the size of a Dbspace file
Dropping a Dbspace File
2 methods to drop a Dbspace file
Adding a Dbspace File
Managing disk storage space using Dbspace files
Seeing Calculation View Results
Generating select statements for results and visualization
Information View Conversion
How to convert information views
Creating a Calculation View from the Union of In-Memory and Extended Tables
How to use unions to create a calculation view
Adding Our Union Calculation View into the Converted Data Model
Replacing old information model with new calculation view
Adding Analytic Privileges and the SAP HANA Modeler Perspective
Understanding the various types of Information Views used in SAP HANA to create analytical reports.
View Data Across Both In-Memory and Dynamic Tiering Tables Using a SQL View
Create and use a SQL view to query data from both in-memory and dynamic tiering tables.
Create a Cube Calculation View (XS Advanced)
Create a graphical calculation view with a cube data type.
Using Table Variable Operators
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
Creating SQLScript User Defined Libraries
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
Use Table Variable Operators
Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.
Parallel Processing and Parameters
Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.
Intermediate Table Variables
Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.
Debugging Stored Procedures
Leveraging SQLScript in stored procedures, user-defined functions, and user-defined libraries.
Creating Table User Defined Functions
Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.
Create SQLScript User Defined Libraries
Leveraging SQLScript in Stored Procedures, User Defined Functions, and User Defined Libraries
Create Scalar User Defined Functions
Leverage SQLScript in stored procedures, user defined functions, and user defined libraries.
Anonymous Blocks
Leverage SQLScript in stored procedures, user-defined functions, and user-defined libraries.