Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming millisecond is required, the following 4 results were found.

  1. Before and After, Highs and Lowshttps://joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    MIN(ExecutionLogStorage.TimeStart) AS [First] , MAX(ExecutionLogStorage.TimeStart) AS [Last] , CAST(CONVERT(CHAR, DATEADD(millisecond, MAX(DATEDIFF(MILLISECOND, ExecutionLogStorage.TimeStart, ExecutionLogStorage.TimeEnd)), '00:00:00'), 121) AS TIME)...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  2. The ReportServer Databasehttps://joellipman.com/articles/else/database/the-reportserver-database.html

    run. TimeEnd datetime NOT NULL Time report finished running? Need to check what finished? TimeDataRetrieval int NOT NULL Milliseconds spent retrieving the data. TimeProcessing int NOT NULL Milliseconds spent processing the report. TimeRendering int NOT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Databases
    • Language: en-GB
  3. Performance Report - Background colors based on dataset valueshttps://joellipman.com/component/content/article/green-red-background-colors-based-on-dataset-values.html?catid=75&Itemid=165

    AS [Data Retrieval] , e.[TimeProcessing] AS [Process Time] , e.[TimeRendering] AS [Render Time] , DATEDIFF(MILLISECOND, e.TimeStart, e.TimeEnd) [Total Time] ,RANK() OVER (ORDER BY e.[TimeStart] DESC) [Rank] FROM...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  4. SSRS Dropdown parameter cannot be blank!https://joellipman.com/component/content/article/ssrs-dropdown-to-allow-blank-values.html?catid=75&Itemid=165

    created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I want...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 1 - 4 of 4