Thanks for the feedback Steve.

I will need to look at some options then for pooling the connections.

Hello,

Apologies to necro this old thread but I have recently encountered this problem on SSRS2017.

SQL Server is on a separate machine.

The same behavior where running a set of reports progressively...

Those are great points both, and the humour is spot on haha.

I think this is what they refer to as "self-service" BI - give us all the data and we...

Thanks Sue.

That link is a great resource!

Cheers,

G

Hi Solomon,

Thank you for the response.

The concern is specifically that the data will be intercepted in transit between the SQL server and NFS whilst using a BULK INSERT.

Cheers,

G

Try the following:

--Load sample data

CREATE TABLE #Invoice (ID INT, InvoiceNumber INT, Created DATETIME)

INSERT INTO #Invoice

SELECT 6,125870808, '2012-12-18 15:45:30.000'

UNION ALL

SELECT 5,125870808, '2012-12-18 12:23:27.000'

UNION ALL

SELECT 4,125870808, '2012-12-18 06:45:06.000'

UNION ALL

SELECT 3,125870808, '2012-12-18...

It appears it is not possible in SharePoint integrated mode; only in native mode.

http://msdn.microsoft.com/en-us/library/ms160348%28v=sql.100%29.aspx

For a report published to a report server configured for native mode, use a full...

Hello,

Apologies to necro the thread but I got distracted before I could respond to the thread.

Thank you for the suggestions Lynn. However I just managed to confuse myself building a...

My original post appears to be ambiguous.

There are multiple databases on the server and I need the login and role for each database.

I couldn't find a link between sys.server_principals and...

Thanks.

I was also adapting the expression for the sub total which put the sum over the entire expression.

My final expression:

=SUM(Fields!Quantity.Value*Fields!Price.Value / SUM(Fields!Quantity.Value))

Cheers for the feedback!

G

Hi,

Thanks for taking a look.

That is essentially the formula I have in place. However in my matrix totals I'm getting 1.35 for total price where I would like to get...

Thanks for your sharing your experience guys.

I was getting the feeling that I was somehow missing something obvious in this.

Hi everyone.

Thanks for taking time to share your knowledge.

The solution I've taken is to update the statistics with full scan on the two tables pTransaction and pTransactionGroup.

Initially I only updated...

Hi and apologies for my splintered responses.

Below are the sats IO results and the execution plans. I believe the sql query can be obtained from the execution plan (right click...

Hi thank you both for your feedback!

It seems that Gila's assumption is correct, at first glance the execution plans for db1 and db2 looked the same in terms of operations...