题目内容
You are the administrator of a SQL Server 2000 database. Using the default options configures the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete.
Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code.
CREATE PROCEDURE GetCustomer
(@CustomerID Int )
AS
SELECT FirstName, LastName, Address1, Address2, City,
State, Zip, MAX(PurchaseDate) AS LastPurchase
FROM Customers C
JOIN Addresses A ON A.AddressID = C.AddressID
JOIN Purchases P ON P.CustomerID = C.CustomerID
WHERE C.CustomerID = @CustomerID
GROUP BY FirstName, LastName, Address1, Address2, City, State, Zip
You want to improve the performance of the procedure by using the least amount of administrative effort. What should you do？
查看答案
搜索结果不匹配？点我反馈
更多问题
If such unhappy persons don't change their bad behaviour, what should people do according
A．currentB．streamC．flowD．flight
第二节 完型填空
阅读下面短文，从短文后所给各题的四个选项(A、B、C和D)中选出能填入相应空白处的最佳选项。
Sisters are often alike but they are never exactly the same. In many 【B1】 , one sister is often called "the pretty one" and the other "the 【B2】 one" when they are still babies. Even young children think 【B3】 is more important than brains. "I envied my sister's looks. She had long 【B4】 hair and nice clothes and the most 【B5】 I hated her so much that I decided to 【B6】 her. One day when the roof of the house was being repaired, I 【B7】 a brick out of a window 【B8】 she was underneath(在下面). Thank God it 【B9】 !" says one ashamed near-murderer. "I must have been about ten at the time, and she was eight years old. 【B10】 she tells me that she always felt 【B11】 beside me in school because I was a 【B12】 student and she was weaker 【B13】 school work. But when you're fourteen or fifteen, you 【B14】 attention and praise and you need boyfriends; good exam results don't 【B15】 a fair exchange(交换)."
Life is particularly 【B16】 for someone who wants to 【B17】 in the footsteps of a famous sister. Dee Dee Pfeiffer wants to be a film star like her sister, Michelle. "When we were children, Michelle was the beautiful one and I was the 【B18】 one," says Dee Dee. "I have been trying to lose weight for years to achieve a 【B19】 which is as good as hers. In Hollywood, everyone 【B20】 you critically(挑剔地), and compares you with your famous sister."
【B1】
A．constantlyB．consistentlyC．permanentlyD．instantly
微信支付 
支付宝支付