SELECT COUNT(Name) AS ExecutionCount, Name, SUM(TimeDataRetrieval) AS TimeDataRetrievalSum, SUM(TimeProcessing) AS TimeProcessingSum, SUM(TimeRendering) AS TimeRenderingSum, SUM(ByteCount) AS ByteCountSum, SUM([RowCount]) AS RowCountSum FROM (SELECT TimeStart, Catalog.Type, Catalog.Name, TimeDataRetrieval, TimeProcessing, TimeRendering, ByteCount, [RowCount] FROM Catalog INNER JOIN ExecutionLog ON Catalog.ItemID = ExecutionLog.ReportID WHERE Type = 2 ) AS RE GROUP BY Name ORDER BY COUNT(Name) DESC, Name;
You probably dont give a damn but does someone know of a way to log back into an Instagram account..? I was dumb forgot the password. I would love any tricks you can offer me!
@Nicholas Gordon thanks for your reply. I found the site through google and im waiting for the hacking stuff atm. I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.
You do this in the Report Manager website. First set the credentials in the shared data source (SDS). The credentials must be hard-coded in the SDS to enable caching or snapshots. Then "Manage" the report in Report Manager and enable caching. Alternately, you could have snapshots be created on a schedule.
Good stuff... thanks for providing real time videos ..,
Sir could you provide this query for calculating (timeprocessingsum,timeretreivalsum,timerenderingsum) for sample ? Thanks in advance.
SELECT COUNT(Name) AS ExecutionCount,
Name,
SUM(TimeDataRetrieval) AS TimeDataRetrievalSum,
SUM(TimeProcessing) AS TimeProcessingSum,
SUM(TimeRendering) AS TimeRenderingSum,
SUM(ByteCount) AS ByteCountSum,
SUM([RowCount]) AS RowCountSum
FROM (SELECT TimeStart,
Catalog.Type,
Catalog.Name,
TimeDataRetrieval,
TimeProcessing,
TimeRendering,
ByteCount,
[RowCount]
FROM Catalog
INNER JOIN
ExecutionLog
ON Catalog.ItemID = ExecutionLog.ReportID
WHERE Type = 2
) AS RE
GROUP BY Name
ORDER BY COUNT(Name) DESC,
Name;
You probably dont give a damn but does someone know of a way to log back into an Instagram account..?
I was dumb forgot the password. I would love any tricks you can offer me!
@Easton Colten instablaster ;)
@Nicholas Gordon thanks for your reply. I found the site through google and im waiting for the hacking stuff atm.
I see it takes quite some time so I will get back to you later when my account password hopefully is recovered.
@Nicholas Gordon It worked and I actually got access to my account again. I am so happy:D
Thanks so much you saved my account!
Nice explanation .. can you provide for SSAS as well..
sure ..Thanks for your feedback and appreciate your time...
Sir how can I download SQL server with all services like SSRS SSIS SSAS
How to enable cached reports??
You do this in the Report Manager website.
First set the credentials in the shared data source (SDS). The credentials must be hard-coded in the SDS to enable caching or snapshots.
Then "Manage" the report in Report Manager and enable caching. Alternately, you could have snapshots be created on a schedule.