OK, thanks.

Your example by replacing the select of the MIN(Name) and MAX(Name) by selecting the name of the Min and Max ID is not valid because in real live the...

I have changed my script, but same result.

Insert in-memory is faster, very fast (Disk: 74 sec, in-memory: 0 sec).

In-memory query is slower: Query on Disk: 0ms, in-memory: 20ms.

USE master;

-- Create...

It is faster with SQL2012.

Is it possible to download and install the MSOLAP version of SQL2012 on SQL2008R2?

Solution from http://www.ssas-info.com:

When you have BIDS helper installed, it's possible to deploy the aggregations only. There is a button in the partitions tab.

However it's not possible to create...

In ie I have choosen Tools / Internet options / in Browsing History - button Delete...

Then checked 'Passwords' / button Delete.

Afterwards tried, but ie isn't asking for login.

It works after I have made a combination of 2 recommendations:

- 1 of Dev: EXECUTE AS LOGIN

- 1 of MarkusB: add VIEW SERVER STATE to DMView.

Thanks.

I have got it working, but don't understand why it works with the procedure:

CREATE PROCEDURE [dbo].[spCounters]

AS

SELECT Reads+Writes FROM master.sys.dm_exec_sessions WHERE session_id=@@SPID

EXECUTE AS LOGIN='DMView'

SELECT cntr_value FROM master.sys.dm_os_performance_counters

REVERT

and not with:

CREATE PROCEDURE [dbo].[spCounters]

WITH...

OK this...

Dev (11/21/2011)

---

aarded (11/21/2011)

---

Dev (11/21/2011)

---

Change you SP to execute it in Login's Context...

EXECUTE AS LOGIN = 'DMView'; -- Context Switch

SELECT physical_io FROM master..sysprocesses WITH (NOLOCK) WHERE spid...

Even with

GRANT IMPERSONATE ON USER::Report TO DMView;

it returns the error.

Dev (11/21/2011)

---

Change you SP to execute it in Login's Context...

EXECUTE AS LOGIN = 'DMView'; -- Context Switch

SELECT physical_io FROM master..sysprocesses WITH (NOLOCK) WHERE spid = @@SPID

SELECT cntr_value FROM...

The error can be reproduced as follow:

USE master;

GO

--Create two temporary principals

CREATE LOGIN DMView WITH PASSWORD = '123456';

CREATE LOGIN Report WITH PASSWORD = '123456';

GO

USE tempdb;

GO

CREATE USER DMView FOR LOGIN DMView;

CREATE USER...

To Krsitian: OK, but sys.sysprocesses works fine.

To Dev: I find it 'normal' because the procedure also failed when I started it with the 'EXECUTE AS DMView' clause.

Yes it is possible to connect with other users.

There many users, admins and others, windos and sql, which can connect.

And with a proxy account, it works with SQL agent.

So I...

I kow!

But I mean that it works with SQL server agent and a proxy account.

I use this as a workaround.

The problem is: I can't set the 'GRANT EXECUTE' permission.

This returns...