SQL Server memory Articles

TroubleShooting SQL Server Memory Consumption

Recently on one of our staging servers had a memory consumption issue and even 32 GB of RAM was looking insufficient and application performance was being impaired. Initially I thought the cause would be poorly designed queries, but after a thorough investigation this turned out not to be the case. I noticed that whenever the […]

Change Select Top 1000 Rows value in SSMS

One seemingly minor change to SQL Server Management Studio (SSMS) in SQL Server 2008 is that by default it will only allow the visually select the top 1000 rows . This is primary to save on memory which can be drained by loading numerous rows into the SSMS visual editor. If, however, you don’t want […]