Shortcuts & tips from an Impatient DBA
This series of short posts will demonstrate some lesser-known features, keyboard shortcuts, and other tips that make my day as a DBA more productive. None of these are groundbreaking super-secret features–they are the little things that I do as part of my daily work that make me more efficient.
CTRL + SHIFT + V
Clipboard ring
This is like a time machine for your clipboard. How often are you multitasking, and accidentally lose something from your clipboard? I have some important query on my clipboard, I’m going to paste it somewhere to save and before I paste it, I copy something else without thinking.
No worries… When CRTL+V pastes the wrong thing, instead use CTRL+SHIFT+V… Each time you use CTRL+SHIFT+V, you’ll go back in time one entry on your clipboard (up to 20 entries, then it cycles back to the first…hence “clipboard ring”). Eventually you’ll get back to the one you wanted. No more lost clipboard entries!
I just tried this in notepad (didn't work), I was really hoping it was an OS feature and not just SSMS!
Unfortunately, it's not a Windows feature. It's actually a Visual Studio feature–so it will work in SSMS or SSDT (or really any VS shell you're working in).