Viewing 8 posts - 1 through 8 (of 8 total)
This thread is timeless. Every time I set up a new instance, I forget about this until my AS400 linked server inevitably stops working a few days later. And each...
December 16, 2020 at 3:21 pm
use [msdb]
Declare @weekDay Table
(
mask int
, ...
November 20, 2017 at 3:57 pm
Also, from the trace, this appears to be the query that causes all the problems:
SELECT
{[Measures].[YTD Qty Itm Sold]} DIMENSION PROPERTIES [MEMBER_UNIQUE_NAME],[MEMBER_CAPTION] ON COLUMNS,
NON EMPTY CROSSJOIN(
[Dim Branch].[Br Nm].[Br Nm].AllMembers,
...
August 19, 2011 at 10:40 am
Yes, I'm on x64 and SQL Enterprise. The SQL service user account is already granted the lock pages in memory right.
I've done a little more testing and it looks...
August 19, 2011 at 10:24 am
Steve - thanks for the input. I'm running SQL 2008 R2 on Windows Server 2003 SP2. I did build the cube, and yes, it is entirely possible that...
August 18, 2011 at 5:54 pm
Viewing 8 posts - 1 through 8 (of 8 total)