题目内容

You are the administrator of a SQL Server 2000 computer. The server contains a database that is heavily indexed and that company users query extensively. The database has grown and query response time has slowed. The database is stored in a single data file.
You want to accelerate query response time. What should you do？

A. On a new hard disk, create a new filegroup. Drop the existing nonclustered indexes, and then re-create them on the new filegroup.
B. On a new hard disk, add a new file to the PRIMARY filegroup. Drop the existing nonclustered indexes, and then re-create them on the PRIMARY filegroup.
C. On the existing hard disk, create a new filegroup. Drop the existing nonclustered indexes, and then re-create them on the new filegroup.
D. On the existing hard disk, add a new file to the primary filegroup. Drop the existing nonclustered indexes, and then re-create them on the PRIMARY filegroup.

查看答案

搜索结果不匹配？点我反馈

更多问题

某城市的居民对高层住宅经历了一个从较为抗拒到较普遍接受的过程，这一现象反映了消费者市场的()。

A. 代性
B. 发展性
C. 地区性
D. 复杂性

A．She'll surely go.B．She's not interested.C．She will not go.D．She will not do her homew

A. She'll surely go.
B. She's not interested.
C. She will not go.
D. She will not do her homework.

本例病人在治疗过程中，出现下列哪一项提示抗胆碱药应当停用

A. 瞳孔较前散大
B. 口干、皮肤干燥、颜面潮红
C. 肺部啰音消失
D. 高热、尿潴留

急性骨髓炎行开窗引流冲洗术后3天内最主要的护理是（）。

A. 鼓励病人早期活动
B. 保持引流管通畅，快速冲洗
C. 观察体温变化
D. 加强饮食护理
E. 患肢制动