David Musgrave reminds us of a technique for Copying small amounts of data in SQL Server quickly. This works really well but David is right. It only works for SMALL amounts of data. Paste too much and you’ll be looking at blank screen for a long time praying that you did this right.