Sounds like you are running out of space.

Even though you using Init to overwrite the file I think the fact that that compression is being used will cause the bak...

Try some of the courses on the MS Virtual Academy.

This one is probably best suited

https://mva.microsoft.com/en-US/training-courses/database-fundamentals-8243

Hi,

I noticed that index maintenance wasn't being carried out on the SSISDB so I updated the stats and rebuilt indexes and this appeared to fix the problem.

Note that I still...

Thanks Luis. I'll check out that MVA course - looks like a good starting point on the differences.

Firstly, according to your data you are selecting where all_ID = 5505 but in your results you have all_ID as 750 so is a bit confusing.

So in both select statements...

Windows Server 2008R2 isn't a supported option for SQL Server 2016.

See link for details

https://msdn.microsoft.com/en-us/library/ms143506.aspx#pmosr

TRY_PARSE is a CLR function which could account for the performance difference.

I think the only benefit of using TRY_PARSE over TRY_CAST is when you need to pass the culture that...

I imagine you would have to set up a profiler trace to monitor if anyone is accessing the cube. I'm not sure about any other logging build into SSAS but...

The query below should show you connections to the SSAS server. Not this is a DMX query not T-SQL.

SELECT * FROM $system.discover_connect

Do the values in your parameter already contain quotes?

If so, in the data set under the parameter tab in the parameter value for state set the expression to be as...

homebrew01 (6/27/2016)

No, this gives me 0 results, using the active trace file

select *

from fn_trace_gettable('D:\TraceFiles\MyDMLtrace_SQL_x160621_x146_10.trc', 1)

where textdata ...

Do you have RPC:Starting or RPC:Completed as Events in your trace?

Are you using the action functionality on the object? And selecting the go to report option?

Any time I have done that then just using the browser back button returns then...

If you want to see the values then you would need to use SQL profiler. Or you can add a a text box to your report and display the parameter...

If it is a multi select drop down then the parameters will be sent to the stored procedure as a comma separated string.

Depending on what this stored procedure does you...