皮皮学,免费搜题
登录
logo - 刷刷题
搜题
【单选题】
你是你公司SQL Server2005/2008数据库的开发者。你在数据库中更新一些为销售部门创建新的月底报表的存储过程。这存储过程包括从三个或更多的表中检索数据的复杂请求。在数据库中所有的表至少有一个索引。用户报告说有一个新的月底报表的运行比以前版本的报表的运行来的慢。你想要提高这些报表的性能,你应该做什么?()
A.
为每个存储过程创建一个包含数据定义语言的脚本。为索引调整向导使用这个脚本作为工作负荷记录文件
B.
在SQL跟踪事件探查器捕获每一个存储的执行过程。为索引调整向导使用跟踪文件作为工作负荷记录文件
C.
在使用存储过程的表中更新统计表
D.
在查询分析器中执行每一个存储过程,并使用Show Execution Plan选项
E.
在查询分析器中执行每一个存储过程,并使用Show Server Trace选项
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
微信内点击右上角“…”即可分享
反馈
参考答案:
举一反三
【单选题】I wondered__.
A.
how much he cost the radio
B.
how much the radio has cost him
C.
how much did he spend on the radio
D.
how much he paid for the radio
【简答题】One night, I wondered what it would be like if I only asked questions. I decided that no matter what anyone said to me the next day, I would reply only with 36 . I loved to read about scientists and t...
【简答题】Twelve years ago, when I was 50,I wondered what 60 or 70 would be like? I looked around and saw only one style of living. It’s not fair, I thought. Young people have so many styles to choose from, but...
【单选题】肝硬化患者出现全血细胞减少最主要的原因是:
A.
营养吸收障碍
B.
骨髓造血功能低下
C.
脾功能亢进
D.
血容量增加
E.
上消化道出血
【单选题】下列诗句,哪一项是正确的
A.
别有悠愁暗恨生,此时无声胜有声。
B.
别有忧愁暗恨生,此时无声胜有声。
C.
别有幽愁暗恨生,此时无声胜有声。
【单选题】下列哪项因素不会造成患者咬颊咬舌( )
A.
缺失时间过长,舌体变大
B.
两颊部向内凹陷
C.
垂直距离过高
D.
后牙覆盖过小
E.
上颌结节与磨牙后垫部位的基托间间隙过小
【简答题】完形填空。 Why did I come today? I wondered. My Christmas list contained (包括) several people. And I knew their feelings would be hurt if I didn't buy them anything, so buying 1 is boring. Hurriedly, I 2 sh...
【单选题】I wondered( )
A.
did he really mean it.
B.
he really meant it.
C.
whether he really meant it.
D.
he really mean it.
【简答题】完形填空。 One night, I wondered what it would be like if I only asked questions. I decided that no matter what anyone said to me the next day, I would reply only with 1 . I loved to read about scientists ...
【简答题】此时无声胜有声
相关题目:
参考解析:
知识点:
题目纠错 0
发布
创建自己的小题库 - 刷刷题