Title: TARGIT InMemory Reference  
Author: Former - Dennis de Gier [X] Dec 04, 2020
Last Changed by: Former - Dennis de Gier [X] Dec 04, 2020
Tiny Link: (useful for email) https://confluence.targit.com/x/PoqjAw
Export As: Word · PDF  
Hierarchy
Parent Page
    Page: TARGIT InMemory platform
Children (2)
    Page: TARGIT InMemory
    Page: Import Tool
Labels
There are no labels assigned to this page.
Recent Changes
Time Editor  
Dec 04, 2020 15:19 Former - Dennis de Gier [X] View Changes
Dec 04, 2020 15:18 Former - Dennis de Gier [X]  
Outgoing Links
Solution Implementation (211)     Page: Starting tiQuery
    Page: CAST_NUM_AS_INT (number)
    Page: What is TARGIT InMemory Database?
    Page: SET PRESERVE DECIMAL
    Page: DROP
    Page: SUM (expression)
    Page: INFORMATION_SCHEMA.QUERY_LOG
    Page: MINLIST (param1, param2, param3 ,.. paramn)
    Page: INFORMATION_SCHEMA.QUERY_LOG_DELTA
    Page: INFORMATION_SCHEMA.COLUMNS
    Page: LAZY LOAD
    Page: Server and Import optimizations
    Page: RIGHT (string, number)
    Page: FLUSH
    Page: LASTPRICEWITHZEROES
    Page: DATEPART (datepart, date)
    Page: REORDER
    Page: WITH
    Page: ATAN (number)
    Page: Refresh TARGIT InMemory Database
    Page: INSERT INTO
    Page: YEAR (date)
    Page: COLUMNEXISTS
    Page: WHILE Loop
    Page: CAST_NUM_AS_DECIMAL (number)
    Page: SELECT DISTINCT
    Page: ACOS (number)
    Page: COS (number)
    Page: DATEDIFFTICK (end_date, start_date)
    Page: FLOOR (number)
    Page: CSTR (expression)
    Page: Security
    Page: CLUSTERED INDEX
    Page: Toolbox item description
    Page: TRY_CATCH
    Page: WITH ROLLUP & GROUPING
    Page: COSH (number)
    Page: VAREXISTS
    Page: COUNT
    Page: ENDSWITH (string, substring)
    Page: RAND() 
    Page: Picking up new TARGIT InMemory data
    Page: GROUP BY
    Page: CAST_NUM_AS_SHORT (number)
    Page: CAST (expression)
    Page: MONTH (date)
    Page: UNION ALL
    Page: CAST_NUM_AS_LONG (number)
    Page: SCRIPTEXEC
    Page: TRUNC (date)
    Page: IMPORT
    Page: Excel
    Page: CEILING (number)
    Page: DECOLUMNIZE Command
    Page: DATASOURCE
    Page: LASTPRICE
    Page: System Specific Tables and Objects
    Page: AVG (expression)
    Page: RIGHT JOIN
    Page: CREATE TABLE
    Page: EXECUTE
    Page: Using the Blue Plus (+) Button
    Page: If
    Page: ORDER BY
    Page: DBSTATS
    Page: TARGIT InMemory ETL Studio
    Page: DAYOFWEEK (date)
    Page: REMOVE (string, start_pos)
    Page: tiLoad
    Page: SRQT (number)
    Page: MAXLIST (val1, val2… valn)
    Page: CASE0
    Page: LCASE (string)
    Page: INSERT (base_string, startPos, strtoInsert)
    Page: Importing into TARGIT InMemory Database
    Page: CAST_STR_AS_DECIMAL (string)
    Page: MONTHNAME (date)
    Page: OVER() _ OVER (PARTITION BY )
    Page: SINH (number)
    Page: CHARINDEX
    Page: CREATE VIEW _ DROP VIEW
    Page: Typical import speed
    Page: LEN (string)
    Page: INFORMATION_SCHEMA.COLUMN_USAGE
    Page: FORCEGC
    Page: PRINT
    Page: JOIN
    Page: CASE
    Page: TABLE VALUE FUNCTIONS
    Page: CLOSEBALWITHZEROES (measure, _DateColumnName_)
    Page: Database Server (tiServer.exe)
    Page: EXIT
    Page: NOCACHE
    Page: CAST_NUM_AS_BYTE (number)
    Page: Eexport to SQL SERVER
    Page: DATESERIAL (yearint, monthint, dayint)
    Page: Google Big Query
    Page: LTRIM (string)
    Page: SLURP
    Page: MongoDB
    Page: INFORMATION_SCHEMA.TABLES
    Page: Assemblies
    Page: RENAME
    Page: CAST_STR_AS_LONG (string)
    Page: TIMESHIFT
    Page: INTERSECT
    Page: CACHE
    Page: ASCII (char)
    Page: DAY (date)
    Page: GETDATE ( )
    Page: ROUND (number, decimal_places)
    Page: SQL Language Reference
    Page: OPENBAL (measure, _DateColumnName_)
    Page: Auto Update Settings
    Page: CHARINDEXSTD
    Page: IMPORTTIMEOUT
    Page: GETUTCDATE ( )
    Page: DYNAMIC SQL – EXEC _ EXECUTE
    Page: MOVENEXT
    Page: DATEDIFF (intervalstring, date1, date2)
    Page: SUBSTRING (string, start_pos)
    Page: Fixed Width
    Page: CAST_NUM_AS_DOUBLE (number)
    Page: CLOSEBAL (measure, _DateColumnName_)
    Page: Database Configuration
    Page: Supported Cultures
    Page: Creating a New Project
    Page: CAST_NUM_AS_SINGLE (number)
    Page: CSV
    Page: Creating an InMemory Database
    Page: Function Overview
    Page: The benefits of an InMemory Database
    Page: TARGIT InMemory Reference
    Page: LASTCHILD
    Page: What is an InMemory Database?
    Page: SELECT*
    Page: INFORMATION_SCHEMA.TABLE_USAGE
    Page: InMemory Data Drivers
    Page: TANH (number)
    Page: CHAR (number)
    Page: After Adding a Data Source
    Page: DATEPARSE
    Page: INLINE TABLE VALUE FUNCTIONS
    Page: REVERSE (string)
    Page: CAST_STR_AS_INT (string)
    Page: HAVING
    Page: MIN (number1, number2)
    Page: USEDISK
    Page: tiQuery - General Shortcuts_Tips
    Page: DATEDIFFMILLISECONDS (end_date, start_date)
    Page: Select Data Source
    Page: TARGIT InMemory Scheduler Management
    Page: SELECT
    Page: MAX (number1, number2)
    Page: INFORMATION_SCHEMA.UPDATED
    Page: ISNULLOREMPTY(column)
    Page: WHERE
    Page: LOG (number, base)
    Page: STORED PROCEDURES
    Page: PIVOT
    Page: DELETE
    Page: POW (number, power)
    Page: Import Tool
    Page: SAVE
    Page: STARTSWITH (string, substring)
    Page: OPENBALWITHZEROES (measure, _DateColumnName_)
    Page: DATE ( )
    Page: Functions and Stored Procedures
    Page: LIMIT
    Page: Schedule Administration
    Page: UCASE (string)
    Page: COUNT0
    Page: Notifications
    Page: CAST_STR_AS_DOUBLE (string)
    Page: TARGITDB.INI
    Page: SET
    Page: LOG (number)
    Page: Declare
    Page: FOR Loop
    Page: SAFECAST (expression)
    Page: EXCEPT
    Page: SCALAR USER DEFINED FUNCTIONS
    Page: SIGN (number)
    Page: TAN (number)
    Page: COALESCE (VAL1, VAL2… VALN)
    Page: UPDATE
    Page: SQLEXEC
    Page: SPLIT_TABLE TABLE VALUE FUNCTION
    Page: FileList
    Page: DATEADD (intervalstring, integer, date)
    Page: ABS (number)
    Page: CDATE (string)
    Page: ASIN (number)
    Page: SIN (number)
    Page: ISNULL (value, alternateValue)
    Page: TRIM (string)
    Page: COLUMNIZE
    Page: CONCAT (exp1, exp2… expN)
    Page: TARGIT InMemory
    Page: Deployment Folder Administration
    Page: LEFT (string, number)
    Page: RTRIM (string)
    Page: tiImport Reference Guide
    Page: REPLACE (string1, string2, string3)
    Page: ATAN2 (number1, number2)
    Page: IIF (condition, valueifTrue, valueifFsalse)
    Page: FILEEXISTS
    Page: USEDISK FLUSH
    Page: TARGIT SSIS InMemory Custom Import Task
    Page: DO PARALLEL …. END PARALLEL
    Page: ALTER TABLE ADD COLUMN