I've only have a redumentry background with SQL 2000 and I would like some advice. I'll get to the point. A guy has a SQL 2000 server with a database that contains a whack of information that is ...

The Table Partitioning feature in SQL Server 2008 R2 has enabled MACROKIOSK to split each database table across multiple physical devices, increasing query execution speeds by up to 100 percent. And ...