Prev: nvarchar max
Next: SQL Maintenance and Backup plans
From: Muhammad Bilal on 3 Jun 2010 10:54
Hi.

I have a database with a single data file. Is there any performance gain if
table are partitioned in SQL Server 2008 and placed on same partition of a
hard disk?

Regards,
Muhammad Bilal

From: Erland Sommarskog on 3 Jun 2010 17:09
Muhammad Bilal (MuhammadBilal(a)discussions.microsoft.com) writes:
> I have a database with a single data file. Is there any performance gain
> if table are partitioned in SQL Server 2008 and placed on same partition
> of a hard disk?

For write and read acceess, no. However, if you have a sliding
windows scenario where you age out old data periodically, table partitioning
makes that operation a lot faster.

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: nvarchar max
Next: SQL Maintenance and Backup plans