TARGIT InMemory


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

  • No labels