Hi, I have a confusion about "in-memory" option. I've been reading about that but I don't understand some features. 2012 SQL Server only work with that to improves analysis engine and columnstore index or can I use "in-memory" tables and databases as 2014 SQL server does? 

Is there any official document about SQL Server 2012 in-memory capabilities?

Hello,

In-memory feature was first introduced in SQL Server 2014, in version 2012 it's not available; see Transact-SQL Support for In-Memory OLTP

Hi, thanks for your help...so then SQL Server 2012 doesn't have any in-memory option feature but Business Intelligence uses some capabilities am I right?

That question is because, I've seen that BI can use some features like xVelocity in-memory analytics...

Again, thanks for your support.

seen that BI can use some features like xVelocity in-memory analytics...

Yes, that's correct, we have the xVelocity engine in Tabular Modeling (SSAS Tabular) since version 2012.

An noted terms like "in-memory" are heavily overloaded. We have several things that we could call "in-memory" if we want. Among these are:

• SQL Server columnstore (xvelocity)
• SQL Server 2014 support for in-memory tables
• The fact that data are cached in memory and later served from that cache (the way it always has been)
• SQL Server, up to version 6.5, ability to have tempdb in ram
• ...

It is easier to focus on the feature per se than on terms like there - which are often invented for more marketing reasons (another such example that also causes confusion is "Always On").