As I am doing lots of experiements on my SQL Server test box, I sometime gets too many files in SQL Server data installation folder - the place where I have all the .mdf and .ldf files are stored. I often go to that folder and clean up all unnecessary files I have left there taking up my hard drive ...

I have received call from my DBA friend who read my article SQL SERVER - 2005 - Introduction to Partitioning . He suggested that I should write simple tutorial about how to horizontal partition database table. Here is simple tutorial which explains how a table can be partitioned. Please read my arti...