Yep. Conor vs SQL
If you use Microsoft SQL Server Developer Edition on your laptop or desktop that you develop on, particularly if you’re using a 64 bit operating system, you may want to check out the setting that allows you to cap its memory usage. On my machine with 4GB of RAM, sqlservr.exe grabbed about 3GB of that while doing some large bulk inserts and effectively crippled my machine until it was done.
Fortunately this is easy to prevent. Since you probably don’t want SQL Server having unrestricted access to all of your physical memory on your workstation, you can right click the server in SQL Management Studio, click Properties, then on the memory tab, set its “Maximum Server Memory” to something reasonable like 1,024 MB. Restart the service when you’re done for it to take effect.