ArchiveMarch 2015

SQL Server check table fragmentation level


If you are using SQL Server, and discover that what should be a simple select query, or particularly multiple select queries that are unioned together with a sort are running slowly, then the issue is your table indexes. This is particularly the case when using Date and DateTime fields for sorting. If you are trying to sort a table or multiple tables by Date, then it is a good idea to add an...

500 daily visitors!


Wow, what a milestone – my blog now receives over 500 unique visitors every day (well the vast majority of days anyway)! Its incredible to think that there is that much information on here that people find interesting! The top post on my blog is (and has been for some time)┬áCalibri and Cambria fonts for Mac, added back in 2013 as part of my move to the world of Mac. Since I moved to the...



Get in touch

I'm available on just about every social media platform out there as RMTWeb.