Ubiquiti Amplifi Router

By Greg No comments

I have been using Linksys routers for years, since my first router, a WRT54G purchased off eBay. So when my most recent router started to die, it was time to look for a replacement and I naturally went to look at the new Linksys routers again.

Using OPTION (RECOMPILE)

By Greg No comments

This week, I was trying to improve the performance of a bit of SQL and noticed that it generated significantly different query plans depending on the parameters passed in. So I tried to work out how to make it run well for all scenarios.