#12. CREATE TABLE ( product_ID IDENTITY PRIMARY KEY, description NONCLUSTERED, product_type, ...) You often query description and product_type, how to improve performance ?
#13. You plan to create two SQL Server 7 databases. One will be used for Online Transaction Processing (OLTP), the other for Decision Support Services (DSS). A client application is designed to capture production information from the DSS database in real time. The application must report product results, trends in a timely fashion, so you are charged with maximizing the performance of the DSS database? What arrangement will ensure the maximum performance for the DSS without significantly degrading the performance of the OLTP database?
#16. An application takes an exec a long time to complete an operation over time, with the addition of inserts and updates, the performance has worsened. You want to check whether the tables are optimally indexed. Which of the following Create Trace Wizard options should you use to capture information to best optimize the tables? (Choose 2)
#17. Four simultaneous connections doing a select, insert, update and delete, respectively. Question: sometimes stops when update/delete after select more than 10,000 rows. How to fix?
#19. Want to increase product prices in db in following manner. Up to $50 increase by 5%, between 50 & 100 increase by 10%, over $100 increase by 15%. How can you accomplish this and minimize performance hit on db?
#20. The Demographic table contains more than 1000 columns. Nearly 90% of the users search & update 20 of the columns. The remaining columns are seldom used but also important. What to improve data retrieval & update performance when accessing the information in the Demographic table?
gen. 0.071
Forum
Master braindump