Query Execution History
Had this with SSMS Tools Pack but upon migrating to 2012 I ditched it in favor of SQL Prompt. The only thing I'm missing is a log of my Query History, time-stamped and searchable.
We’re still tracking this suggestion, keen to hear from more of the community about use cases. Do get in contact if this is important to you.
I was SOOOO hoping to see query execution history in V10.....
Some usage scenarios
- With appropriate options (save to a separate database) it becomes an awesome library of sql I have executed to search when I need to do something.
- Huge time saver when I need to run that one-off query again that wasn't so one-off
- 'Did you run a query that did this?' Let me look. No, here's the query I ran on this date at this
time. *BONUS* Option to save to GIT! That would really rock the house.
- Life saver when I clear a close a tab/crash/whatever and need that query I was testing.
Ok yeah went a little off the rails there. Seriously, I probably wish one a week 'damn I wish sql prompt had execution history'
So just once again to push this to the surface as I've now twice this week lost a set of queries because I accidentally closed the tab (Yeah, I know..idiot). I don't want to have to purchase SSMS Tools Pack to JUST get execution history (and they don't have a license for a single user that can float machines or honestly, at this point, I'd have bought it). PLEASE Red Gate. SQL Prompt needs this BADLY.
For what it's worth, another use case is what I just did. I closed the @#$!@#$@# tab by mistake. Lost six one-off queries. Execution History would have made me think 'I love Sql Prompt' (I do this pretty regularly anyway)
And I want to second Adam Machanic on his use case - this is a big one. I also have to concur with prior posts of this being a gap on SQL Prompt.
Absolutely would love to see this added. Miss it so much from SSMS Toolkit. It had excellent features on this for storing it into a database table as well. Being able to see the history of every command you executed can be a life saver in certain situations. We're part way there with tab history, but honestly, I find it to be sort of useless. Sometimes I get lucky and something is in there I want but most of the time it's not. I'd rather ditch tab history in favor of execution history (or keep both if that works)
Adam Machanic commented
Sorry, a bit late on replying regarding use cases.
I am often asked to do "one-off" analysis or debugging. For example, "what is the deal with this bad-looking data point?" So I'll go in, run a bunch of queries, figure things out, resolve the situation, move on with life. Now, 3 months later, "I think we're hitting that same weird issue again that you resolved 3 months ago. Can you help?" And at this point, I don't recall what I did. I didn't save the scripts I wrote at the time, because it was just a one-off exercise. And this is where the history kicks in. IF I had it enabled, I'd simply search my archives, find my queries, and save myself potentially a few hours of time. My customer is happy, Red Gate has saved the day and proven its value, and I'm elated to have not had to waste my time. Win-win-win for everyone!
Adrian Brough commented
I do a lot of checking of data issues and related data analysis. This involves running lots of quires one after the other as I try to understand data (or issues therein). It would be really useful to be able to scroll through back what I have run to avoid having to keep a screen full of statements that I am not currently using but don;t want to lose in case I need them again. Being able to search the history for a particular column name of such like would be even better.
Adam Machanic commented
I just came here specifically to request this feature. I don't know why it would be low on your backlog just because it's in some other product. You're not selling some other product and it's a *huge* gap in yours. Please implement it. I don't want to install two products with overlapping functionality.
James Smith commented
I would really like to see this option in Red-Gate also.
User Voice commented
I use ApexSQL Complete (free) to record and search all executed queries!
Would be nice to include in SqlPrompt
I'd like to second this request and agree with Stephen's comment as well. Since you have now implemented colored tabs, the only thing keeping me from fully migrating to SSMS 2012 is the fact that SSMS Tools is now pay-to-use for SQL2012. As for David's comment, I currently have both installed, on 2008, but would prefer to just run 2012. Perhaps this would be a competitive advantage?
With SSMS Tools package migrated to a pay-to-use item for SQL2012, perhaps there's more impetus behind Red Gate adding this feature. Please...
I thought that the feature sets between the SSMS Tools Pack and SQL Prompt were predominantly different, so we definitely wouldn't encourage you to just install one at the expense of the other. The query history is already on our feature backlog, although because of the SSMS Tools Pack it has always remained quite low.