Ad-hoc queries

  • Hello....

    What are ad-hoc queries????? and what BI tools we can use for MSSQL server..??

    Thanks & Regards,
    Pallavi

  • ad hoc queries are generally queries that are not known to the query processor prior to execution (unlike stored procs for example).

    BI tools, the Microsoft BI stack is available if you already bought SQL Server licenses.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply