sqlazuretutorials.com You can improve database performance by using stored procedures and views. A SQL stored procedure is compiled SQL code. Benefits of stored procedures include faster execution, parameters support, security mechanism, and simplification of complex code. In our demo tutorial video on SQL azure, we create one stored procedure that pulls data from CUSTOMER table using two input parameters. The next SQL stored proc processes data from PRODUCTS and CATEGORIES tables where we can do Products by Category. First we create a new table with a Clustered Index in SQL Azure. Using an INNER JOIN with GROUP BY, we pull the Average price for each CATEGORY. We insert this into Summary table, this is still part of the Azure stored procedure. A SQL view which is simply a virtual table. Advantages of SQL views include simplicity of complex code, security mechanism and the ability to use SELECT statement. We create a view between two tables in the cloud database on SQL Azure server.
Science & Technology