creating database on compressed drive

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

Yes it is possible.

SQL Server 2008 has row/page compression option. You can utilize it.

Compressed drive for SQL Server database is to be used only if you don't have any other option.

Because it is synchronous operation and can slow down SQL Server.

Shivrudra SSCrazy Points: 2835 More actions · Answer 2

Thanks,

can you please provide me the sample Example (Script) for same

Regards,
Shivrudra W

Suresh B. SSC-Insane Points: 22986 More actions · Answer 3

row/page compression supports tables and indexes.

Sample:

CREATE TABLE T2

(c1 int, c2 nvarchar(50) )

WITH (DATA_COMPRESSION = PAGE);

GO

For more information please see BOL.