The following best practices can be considered while using the views, batches, stored procedures, and functions in SQL Server 2005: Create small stored procedures: Keep the stored procedures as small as possible. This is useful in a situation where two users are accessing the same stored procedure at the same time | Collaborate Chapter 4 Knowledge Byte In this section you will learn about Creating partitioned indexes System-defined stored procedures Creating Partitioned Indexes Read the following topic in the section Creating and Managing Indexes of Chapter 6 of the book Querying and Managing Data Using SQL Server 2005 Creating Partitioned Indexes System-Defined Procedures Read the following topic in the Appendix of the book Querying and Managing Data Using SQL Server 2005 System-Defined Procedures NIIT Querying Managing and Administering Databases Using SQL Server 2005 .
