I’m moving back to Windows

http://www.zdnet.com/blog/diy-it/why-ive-finally-had-it-with-my-linux-server-and-im-moving-back-to-windows/245?tag=nl.e539 Can you imagine my rank naivety here? I actually said Okay to a Linux update. I know I should have known better. I know I should have, instead, formatted another hard drive, dd’d my furry little pile of files over, downloaded the source tarball, compiled everything all over again, prayed to Linus, turned my […]

Covered Indexes

Covered Indexes are like the greatest thing in the world. This is the chief reason #1 that SQL Server is better than Access, mySQL, Excel, etc http://use-the-index-luke.com/sql/clustering/index-only-scan-covering-index Index-Only Scan: Avoiding Table Access ——————————————————————————– The index-only scan belongs to the most powerful tuning methods at all. It utilizes not only the clustering of rows with similar […]