... to measure with the default installation are the times taken for "data retrieval", "processing", "rendering", and then the totals of these.
I haven't Googled this at the time of print so there may be ...
...
e.TimeDataRetrieval + e.TimeProcessing + e.TimeRendering AS TotalTime
FROM
[ExecutionLog] e
INNER JOIN [Catalog] c ON c.ItemID=e.ReportID
WHERE c.Name='My Amazing Report' -- just change the value ...
Amazing, I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation ...
... kick up the backside to the commercial solutions and for them to perhaps invest/develop/improve on their services, or re-evaluate their fees, hint hint ).
By the way, it's hard for me to tell which ...
... but I spent over an hour before I gave up trying to get SWITCH to work. Instead I cheated and got the ordinal in the Transact-SQL query:
CASE DATEPART(DAY, [MyDateValue])
WHEN 1 THEN 'st'
...
... design and development agency based in Wellington, New Zealand providing consultation, website design, development and usability evaluation services."
Their website has initiated a Web Definition ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.