Hey, It’s quite a well known fact that indexes can be good for your queries. They offer a shorter route to your data, and take some load off your server. They achieve this by creating a Balanced Tree (B-Tree) with pointers to your data. So in a table with customer names, if you search for […]
Hey, So wedding season is over and it’s back to reality, and back to getting beat up by SQL! As a follow on from my last post, SQL Server 32 Bit and AWE, I wanted to cover the topic of monitoring your memory. So as you may have noticed when you enabled it, if you
Hey, Just a quick post based on some questions on performance boosts I received at the presentation the other night. There are so many ways to tune your SQL Instance/application, but for someone who wouldn’t be too comfortable going in deep, the biggest bang for the buck, for me, comes from loading your server with
