Tabular Model in SSAS

Tabular Model SSAS

Tabular models are in-memory databases in Analysis Services. The xVelocity in-memory analytics engine (VertiPaq) delivers fast access to tabular model objects and data by reporting client applications such as Microsoft Excel and Microsoft Power View.

Tabular models support data access through two modes: Cached mode and DirectQuery mode.
In cached mode, you can integrate data from multiple sources including relational databases, data feeds, and flat text files.
In DirectQuery mode, you can bypass the in-memory model, allowing client applications to query data directly at the (SQL Server relational) source.

Tabular Model in SSAS was last modified: October 1st, 2017 by Justin Antony

How to select Lookup cache option in SSIS

Lookup cache option SSIS

Full Cache – For small lookup datasets
No Cache – For Volatile lookup datasets
Partial Cache – For large lookup datasets

The Full cache is optimal but it will take more memory and partial cache is little expensive than full cache mode. No cache will not use any memory and it will take longer time.

How to select Lookup cache option in SSIS was last modified: October 1st, 2017 by Justin Antony

Find active lock on the system in sql server

Active lock sql server

IF we want to know which locks are active in the sql server we can use the following statement

EXEC SP_LOCK
EXEC master..SPDBLOCKS 'Database Name'

This will give the SP and Database Id and the object along with its Mode and Status.

Find active lock on the system in sql server was last modified: October 1st, 2017 by Justin Antony