Customer Question: How can I open an unshared worksheet using just the keyboard?
Ctrl+Shift+N on an existing worksheet is the easy answer.
Customer Followup Question: But, if you’re currently ON an existing unshared worksheet, this won’t work.
Then, you need to hit ALT+F10.
Jeff, What is an Unshared Worksheet?
An unshared worksheet is a SQL worksheet that has a dedicated database connection behind it. These come in handy when your database connection is busy doing OTHER things.
The ‘problem’ with Ctrl+Shift+N is that it only works if you’re on the main/original worksheet. You CAN’T open a new unshared worksheet from an existing unshared worksheet. To keep these connections ‘private’ or exclusive to the worksheet, we do ‘special things’ in the code. And as a result, you can’t spawn one unshared worksheet from another one.
But, you can do THIS.
Enable in preferences:
So when you connect, you get a worksheet by default. Use it. Go crazy. Run a run long running query, and need another? Ctrl-Shift-N will get you a new worksheet, and a new connection.
Go crazy some more. Need another worksheet/connection?
Then pick your new connection – this dialog is keyboard-able.
Close ‘Em, or Suffer the Wrath of your DBA
Connections aren’t free. They require server process(es), database resources, and more. Abuse the system, and you will have to turn in your db credentials. And then you can’t have fun writing SQL anymore.