Archive
Intermittent Lockups with SSMS 2012
First off this post should have been pressed long ago (5/31/2012), but for whatever reason I merely saved it to draft rather than publish it. So without further ado…
Not long ago I started to encounter very intermittent lockups with SSMS 2012. I searched the web hi and low to see if anyone else had encountered this very problem, but I ended up with nothing remotely close. So I decided to turn to twitter and posted my issue to the sql community using the #sqlhelp hashtag.
has anyone experienced random unresponsiveness with SSMS 2012 to a point where you have to kill the process? #sqlhelp #sql
— Samson J. Loo (@ayesamson) May 24, 2012
It wasn’t long until I received a tweet from J. Verheul (@DevJef | Blog)
@ayesamson: Yes. Are you running into this issue constantly, or just once? Problem might come from shared DLL’s with VS2010…
— J. Verheul (@DevJef) May 24, 2012
And that’s how our glorious conversation began… Then @DevJef mentioned he reinstalled SP1 for VS2010 and that cleared up his problem.
@ayesamson: I had the same issue. I actually fixed it by applying VS210 SP1 again. This might help you as well! #SQLHelp
— J. Verheul (@DevJef) May 24, 2012
So I followed suit and applied SP1 for VS2010 and I am happy to report that I am no longer experiencing random lockups with SSMS 2012! Thank you @DevJef and thank you sql community for always being there!
Please visit Jef’s post (#SQLHelp – SQL 2012 Management Studio Freezes). His insight helped me tremendously and save me a lot of frustration and headaches!
Extending Recent Files List in SSMS 2012
If you are like me you save most (if not all) of the scripts or queries that you create. It is just a huge time saver and with our aggressive work load we need all the time we can spare. In my case I deal with a significant volume of production deployments/promotions so I burn through scripts frequently.
On a few occasions (when I need it most of course) the file names often drift from memory so I sometimes look to my recent file list in SSMS to help jog my memory. Yes we have deployment request which I can easily reference but this post is about SQL Server Management Studio, so there. 
Back to the subject… by default SSMS 2012 will only display the last six but what if you want to extend that number to 10 or more?
I’d like to point out that Jugal Shah (blog | @imjugal) published an article that covers SSMS 2000, 2005, 2008 and 2008 R2. Here is the link to his article if you would like to read his post Change Setting for Recently Used Files in SQL Server Management Studio SSMS.
The process is pretty much identical with SSMS 2012 and you go about it like so…
Step 1: Tools >> Options
Step 2: Increase the value for: “items shown in recently used lists”
Step 3: Let’s Verify
The change is immediate, so there’s no need to close and reopen SSMS.
Flickr Photos
|
