Many if not most applications can display the results of SQL queries in some human readable format. However, they typically either must be open with an active window (SSMS or excel for example, both of which take significant system resources on local machine) or involve extra overhead generating reports (SSRS is good example). My platform is Microsoft SQL server. With SSMS, there is also the issue that you must find the right query, get a window open and hit execute.
What method would you use to simply execute read only queries with arbitrary content (could be stored procedures, dynamic queries, CTE's etc.) as instantaneously as possible? The display format could be quite minimal (simple table with almost no formatting changes) with aggregated data not to exceed a very small record set (certainly under 1000 records on average).
I am thinking that something like autohotkey could do this in real time. If I could map a keystroke combo to queries, I'd have the results super fast.
A good example of what I am trying to avoid is as follows:
I like to frequently check the number of users logged into a system by querying a table that sends back no more than 10 records. This should actually take less than one second to view those results. However, because I have it stored in an SSRS report, I must navigate to the website and go through a report generation process that likely takes me 15-40 seconds. I'd like to provide users with a method of seeing the data instantly. How would you accomplish this?