![]() Utilize Try-Catch error handling and learn why to use it Write code within the context of a transaction to prevent data corruption Understand indexing and its impact on speed of retrieval of data and when to not use it. Perform various joins between tables to reunite data stored separately such as an order and its details, or a salesperson and their sales and the product in the sale. Read an SSMS Execution Plan and understand it and learn why you need to understand it.Įxplain and perform single table queries and the proper method to develop them ![]() Use the Database Tuning Advisor for faster queries Work with SQL Server Integration Services to do a basic package for import/export, how to save it and automatically execute it. Use the debugger with a query to troubleshoot it Run a trace in SQL Profiler to analyze performance of operations Use the Template manager in SSMS to quickly import correctly formatted code that was prewritten by the SQL communityĬustomize the SSMS environment to match the users individual needs Use the Object Browser in SSMS to locate objects and view their dependencies so you know the potential effect of a change.
0 Comments
Leave a Reply. |