Which Transact-SQL statement should you execute?

You design a maintenance plan for a SQL Server 2008 instance that contains a database
named SalesDB.
The SalesDB database includes spatial indexes to support queries on spatial data.
You need to perform physical consistency checks on SalesDB. You also need to ensure that
the performance effect on the SalesDB database is minimized.
Which Transact-SQL statement should you execute?

You design a maintenance plan for a SQL Server 2008 instance that contains a database
named SalesDB.
The SalesDB database includes spatial indexes to support queries on spatial data.
You need to perform physical consistency checks on SalesDB. You also need to ensure that
the performance effect on the SalesDB database is minimized.
Which Transact-SQL statement should you execute?

A.
DBCC SYS_CHECK (SalesDB);

B.
DBCC SQLPERF (SalesDB);

C.
DBCC RSPAIRDB (SalesDB);

D.
DBCC CHECKDB (SalesDB);



Leave a Reply 0

Your email address will not be published. Required fields are marked *