SSMS 2008 and CTRL-N (Control – N)

Like most developers I learn my doing or, in the case of my work laptop, by installing and using lots and lots of Software. The result: performance issues. Terrible, terrible performance issues. Over the last few weeks everything from opening Outlook to building a project in VS 2008 have grinded to a halt. This weekend I performed the first rebuild in 18 months….

The problem:

My setups is the same as before, same OS, same Visual Studio versions, same SQL installation…I had heard rumors that some of my shortcut keys might break, depending on how I installed SQL, and only this morning did I notice that two of the keystroke combinations that I use most often in SQL Server Management Studio 2008 – CTRL-N (New Query), CTRL-SHIFT-M (Specify Values for Template Parameters) were missing!!!

If this isn’t a bug, I implore you to tell me what it is:

The (ugly) Fix:

Playing around a little I found the keyboard settings under Environment in Tools->Options. The options were simple – standard (the default…) or SQL 2000. There are some newer shortcuts in 2005/2008 that I didn’t want to lose – but none that had as great an impact as the aforementioned CTRL-N and CTRL-SHIFT-M. I switched to SQL 2000 and lo-and-behold the commands worked again.

Switching back and forth between the two schemes in order to determine what I was gaining and losing I noticed something interesting: when I returned to standard the CTRL-N and CTRL-SHIFT-M combinations stayed in tact, along with my SQL 2008 commands!!! The best of both worlds I guess….

Comments

Muhammad Haroon said…
I have a one-word suggesstion for you: virtualization.

Between a combination of Virtual PC, Virtual Server 2005, and VMWare Server I have use on several machines for different purposes, coupled with XP and Vista's functionality to rollback in time, I have not had to "rebuild" my critical machines in several years since I started using virtualization.
March 13, 2009 at 1:13 PM
Jason said…
I have a two-word response: crappy laptop :o)

Normally I would agree with you 100% - virtualization is the way to go. I am pretty well versed in most of the mainstream virtualization technologies and the organization I work for is in the middle of a pretty large virtualization project. However, given my current (out-dated) work laptop, it is not an option in this case. I'm hoping to get an upgrade sometime soon but for now a rebuild was the only option. I'm not sure if you've seen, but i am really excited about the ability to boot from a VHD in Windows 7! That could be the best of both worlds in my situation!

Thanks for the advice though!
March 14, 2009 at 2:17 AM
Howard Pinsley said…
Thank you for the Ctrl-N fix! It has been driving me crazy!
March 26, 2009 at 12:20 PM
Unknown said…
Thanks, CTRL+N was driving me nuts. This worked perfectly.
March 27, 2009 at 12:33 PM
theo said…
Instead of switching back and forth between Standard and Server 200, put it on standard and click the "Reset to Default" button in the lower right hand corner.

Sometimes during install or upgrade of SQL Server features the hotkeys get overwritten or deleted. Usually clicking "Reset to Default" Will restore. I had the same issue described above and this solved it.
March 15, 2010 at 2:48 PM
Post a Comment

Popular posts from this blog

Mirth

Image
Introduction Let's talk about Mirth. At it's simplest, Mirth  link is an Open Source HL7 interface engine. HL7 (Health Level 7) is an NPO involved in the development of healthcare standards and the HL7 v2.x and HL7 v3 standards are commonly used in Medical Information for data interchange - including but not limited to clinical, financial, logistical and administrative messaging. I first ran across Mirth over a year ago on a personal quest to find an alternative to our client's legacy HL7 application. Academically, I wrote a number of lexical analysis tools using lexx, yacc, bison and JavaCC and knew the challenges of writing and maintaining complex parsers. I was simply looking for something that could parse HL7 for us, and perhaps log messages and provide a little more transparency than our application currently allowed.  A year later and our legacy application is still going strong (read: my proposal was declined), but Mirth is being used in production, far away from th
Read more

Excel - Adding an existing Pivot table to the data model

Image
  I've been working more with, and continue to be amazed by, Power Pivot. I recently ran into an issue where I needed to add the data for an existing Power Pivot report to the Data Model. There is a checkbox that makes this easy when creating a PivotTable: As so often happens, the analysis grew in scope/importance and I found myself needing to add the data to the data model. While it's not obvious how, there is a way to add an existing Pivot table to the data model. There's a More Tables... link in the PivotTable Fields pane.  Clicking on the  More Tables... results in a dialog confirming that you want to Create a New PivotTable .  Doing so will result in the creation of the new PivotTable in a new sheet. By default the data is added to the data model. You'll likely lose some formatting but for anything other than a trivial PivotTable, this should save effort, as it did for me.
Read more

Getting Started with Mirth (Part 1)

Image
This is the first post in a 2 part series. The second post is here Recently I posted about my positive experience when using Mirth by Webreach as an open source communication layer between one of our in-house applications and a third party and proprietary web service interface. That post received a large amount of attention (relative to my other posts :o) ) so now I will post a quickstart guide to creating a similar setup. In this post I will go over the very basics of using Mirth (please dig in and play around with some more advanced options/configurations), specifically I will demonstrate how to use Mirth to read data from a database, package the data up in a SOAP envelope, send the data to a web service and process the SOAP response. I'll also show you how easy it is to monitor channels once deployed. Once you've installed and opened Mirth for the first time you'll be presented with an empty dashboard - but it wont stay empty for long. This is where you'll s
Read more