Speed up your coding by SSMS feature Cycle Clipboard Ring

Shortcut keys its most useful tool in every coding work. Copy (Ctrl+C)/Cut (Ctrl+X) and Past (Ctrl+V) are three of the most useful shortcuts for a developer and DBA in their day to day work. This tool (or option) have only one big problem - we generally can paste only single data that we copied the last time.

What happens if we need more of that? Can we paste more than one item that we copy or cut without going back? It would be nice to have a clipboard history or some window/utility to go back and choose from all copied content.

One of the new provided features and improvements in SQL Server 2012, was a "hidden" feature that called Cycle Clipboard Ring. Sound interesting, right?

It's a Management Studio (SSMS) feature actually provide us exactly what we need! We can keep the content of the last 20 items which we have copied (or cut) and after that reuse them without going back and without copying and pasting multiple times.

How it's work:

• Let's say, that we copied 10 words (or query parts) ... simple Ctrl+C, one by one, without any saves or any special manipulation. After copying (or cutting) just press Ctrl+Shift+V.
• When we press it the first time, it will paste the 10th word that we copied or cut. If we press "Ctrl+Shift+V" again (two times), it will paste the 9th, after that 8th and so on we can repeat paste any of the saved words which we want.
• Instead of using shortcut keys, we can use a long way, go to Edit menu in SSMS and click on Cycle Clipboard Ring, it also pastes the last query.

Simple!

Now we can even close few browser tabs ??