Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to tune a stored procedure?

Answer Posted / vimal

Store procedure is a pre compiled code
it is doing single task of several task
it is used to reduce the execution time
if we want to call store procedure just we call its name

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default sql server instance name?

1011


What is the use of partition by in sql server?

913


What is a result set object returned by mssql_query()?

1134


How do I edit a stored procedure in sql server?

907


Explain tablesample?

982


What is a filestream?

974


What is difference between table aliases and column aliases? Do they affect performance?

953


What is bulkcopy in sql?

935


Why we use functions in sql server?

1054


How to create indexed view?

1028


What is the name of the system variable that returns the number of rows affected by a SQL statement?

996


What does null mean?

973


What are the 10 characteristics of data quality?

942


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1974


What is a raid and what are different types of raid configurations?

1252