You can use the user(s) you've put into the Server administrators for SSAS - right click on the instance in the Security tab.

How do you want the users use your Cube?

Application, t-sql, MDX, excel, other ?

When you execute it from ssms it gives you the account under which the sql service is running.

SELECT SUSER_SNAME() run from ssms should give you the same result as from...

Shortly:

-View is just a sql statement.

-Indexed views have advantages and disadvantages.

-If the sql statement that you'll put in the view's definition does join multiple tables and includes aggregate function(s) than...

DECLARE @dyn_sql NVARCHAR(max)

DECLARE @table_name NVARCHAR(100)

SET @table_name='MyTable'

SET @dyn_sql='CREATE TABLE '+@table_name+'('+CHAR(10)

DECLARE @i INT=0

WHILE (@i<300)

BEGIN

SET @i+=1

IF (@i<300)

SET @dyn_sql +='Column'+CONVERT(NVARCHAR(3),@i)+' varchar(255),'+CHAR(10)

ELSE

SET @dyn_sql +='Column'+CONVERT(NVARCHAR(3),@i)+' varchar(255)'+CHAR(10)

END

SET @dyn_sql+=')'

PRINT CAST(@dyn_sql AS NTEXT)

robolance (10/31/2014)

---

I ran both versions against a DB table with about 1.2 million rows.

Without the get days it took 35 seconds.

With Igor's version it took 39 seconds.

With my version...

robolance (10/29/2014)

---

CREATE FUNCTION dbo.fnGetMonthDays(@myDate DATETIME) RETURNS INT

AS

BEGIN

return DATEDIFF(d, DATEADD(month, DATEDIFF(month, 0, @mydate) , 0) ,DATEADD(d, -1, DATEADD(m, 1, DATEADD(month, DATEDIFF(month, 0, @mydate) , 0)))) +...

It's good when you're doing it...

GilaMonster (10/20/2014)

---

Cardinality estimator assumes that, when there are multiple predicates, they are completely independent (if one affects half the table and the other affects 10% of the table then the...

Of course you can.

I'm interested in your case.

I'll need to implement only Reorganize with update stats of indexes because of a Standard edition.

Are your tables very big and having high fragmentation? Are...

First thing, go to sql server configuration manager and check the protocols, check the services states. After changes restart the services.

Second thing could be the Firewall, but since you've installed...

High CPU over 95% on long time periods holds the possibility to go to 100% at times and then is the good probability for deadlocking.

I've read in a performance poster...

Thanks, this is going to be considered.

It's the same for BI edition....

My question too. The solution can be easily replaced with set-based. Then everything is easier.