单选题
Your database is 5GB and contain satable named Sales History. Sales informationis frequently inserted and updated. You discover that excessive page splitting is occurring. You need to reduce the occurr enceof page splitting in the Sales History table. Which code segment should you use?（）
发布日期：2021-09-28
A
ALTER DATABASE Sales MODIFY FILE(NAME = Sales dat3, SIZE = 10GB)
B
ALTER INDEXALL ON Sales.Sales History REBUILD WITH (FILLFACTOR = 60)
C
EXEC sys.sp_configure 'fill factor (%)', '60'
D
UPDATE STATISTICS Sales.Sales History(Products) WITH FULLSCAN, NORECOMPUTE
标签： "暂无标签"
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
热门试题热门资讯 相关试题