You are a database developer. You plan to design a database solution by using SQL Server
2008. The database contains a table that is stored as a heap. You perform page-level
compression on the table. When data is added to the table by using BULK INSERT, the new
pages are not compressed. You need to ensure page-level compression for all data pages
when they are allocated to the table. Which query hint should you use?
A.
PAG LOCK
B.
NOLOCK
C.
NOWAIT
D.
TABLOCK