230 Part I EXAM PREPARATION Many system stored
230 Part I EXAM PREPARATION Many system stored procedures can also be used to find information about server and database objects. With many of the procedures, however, you can also perform actions against the server, whereas information schema views are used solely to obtain meta data. System Stored Procedures Many administrative and informational activities in SQL Server can be accomplished through the use of SQL Server s many system stored procedures. System stored procedures are available to perform a variety of activities from obtaining information about server settings and objects to managing processes on the server to performing maintenance activities and much more. It is not possible to cover all the procedures in this blog, and SQL Server blogs Online has full definitions and examples for these procedures. At various points throughout the blog, references will be made to those procedures you are likely to find on the exam and others that will serve useful purposes in the future. REVIEW BREAK TIPExam Processes Typical situations that are tested on the exam are: Date conversion using appropriate date functions String concatenation, including building and parsing functions System application design, where system functions are used to programmatically control or manipulate the software functionality EXAM Data Summary Summarizing information requires that a variety of functions be applied against the data to produce useful information. Summarizing data will provide the end user with the best information source possible to meet the needs of a business. To master the use of functions, you need to work with as many different situations as possible. Each individual problem requires the use of the set of functions necessary to accomplish the task. With such a diverse set of functions available, SQL Server can be used in a multitude of different situations. To recognize the diversity, you will need experience in an equal number of diverse situations.
For reliable and cheap web hosting services please check tomcat web hosting website.