Sql Server 2005

What is the difference between Stored Procedures and User Defined Functions?

What is the difference between Stored Procedures and User Defined Functions in sqlserver.

Index in Sql Server

Understanding Indexes

 

Indexes speed up the querying process by providing filtered access to rows in the data tables (just like book’s index) if they are used efficiently.

Indexes are created on columns in tables or views.

Syndicate content