34,837
社区成员
发帖
与我相关
我的任务
分享做过Brainbench的测试的请进
认证需要，MS SQL Server 2000 Administration/Programming相关，现在没有Free Test了，Test Center要收费，有经验的谈谈经验吧，或者提供相关测试练习也可，谢谢
...全文
请发表友善的回复…
发表回复
pbsql 2005-12-05
- 打赏
- 举报
如javanow(想我生命的意义)所言
klan 2005-12-05
- 打赏
- 举报
有标准答案嘛？
javanow 2005-12-05
- 打赏
- 举报
我选 1)
1) Have the developer incorporate the Transact-SQL code into a stored procedure.
使用 stored procedure 不需要重新编译的时间。
1) Have the developer incorporate the Transact-SQL code into a stored procedure.
使用 stored procedure 不需要重新编译的时间。
superunusa 2005-12-05
- 打赏
- 举报
没有用过这个工具。估计需要去国外找高手了。
boboshazhi 2005-12-05
- 打赏
- 举报
4
pbsql 2005-11-30
- 打赏
- 举报
怎么没人参与呢？
点点星灯 2005-11-29
- 打赏
- 举报
http://brainbench.com/
点点星灯 2005-11-29
- 打赏
- 举报
第一次听说。
子陌红尘 2005-11-29
- 打赏
- 举报
没做过这个，呵呵
pbsql 2005-11-29
- 打赏
- 举报
比如说都有些什么题型、需要注意些什么问题、该做哪些方面准备等等
pbsql 2005-11-29
- 打赏
- 举报
这个比较有意思，看看下面这道题，你会选择哪个答案：
Question #5
A VB developer comes to you, wanting your advice on the fastest way to implement some code in a SQL Server-based application she is writing. Essentially, the code is used to look up some values used to populate a drop-down box on one of her program's screens. The code uses a triple join to produce the necessary output for the drop-down box.
You take a look at the VB code and notice that the developer is using an ADO Recordset object with a Transact-SQL string to access the data on SQL Server.
The developer tells you that this particular code will run thousands of times each day, and because of this, it must perform as quickly as possible. In addition, the results of this query will vary from day-to-day as the underlying data in the tables change.
What, if any, suggestions can you offer the developer to boost the performance of her code?
1) Have the developer incorporate the Transact-SQL code into a stored procedure.
2) Have the developer rewrite the code in the form of a SUB SELECT, instead of trying to join three tables together to produce the necessary output.
3) Suggest to the developer to add an appropriate query hint to the code to speed up access to the data.
4) The developer can't do much to boost the code's performance, but as a DBA, you can do a better job of optimizing the indexes to speed it up.
Question #5
A VB developer comes to you, wanting your advice on the fastest way to implement some code in a SQL Server-based application she is writing. Essentially, the code is used to look up some values used to populate a drop-down box on one of her program's screens. The code uses a triple join to produce the necessary output for the drop-down box.
You take a look at the VB code and notice that the developer is using an ADO Recordset object with a Transact-SQL string to access the data on SQL Server.
The developer tells you that this particular code will run thousands of times each day, and because of this, it must perform as quickly as possible. In addition, the results of this query will vary from day-to-day as the underlying data in the tables change.
What, if any, suggestions can you offer the developer to boost the performance of her code?
1) Have the developer incorporate the Transact-SQL code into a stored procedure.
2) Have the developer rewrite the code in the form of a SUB SELECT, instead of trying to join three tables together to produce the necessary output.
3) Suggest to the developer to add an appropriate query hint to the code to speed up access to the data.
4) The developer can't do much to boost the code's performance, but as a DBA, you can do a better job of optimizing the indexes to speed it up.
duoluohuifeng 2005-11-29
- 打赏
- 举报
这是啥东东啊
zlp321002 2005-11-29
- 打赏
- 举报
进来,数星星...顺便接分....
pbsql 2005-11-29
- 打赏
- 举报
现在测试都收费了，据说以前是有免费的
