Difference between writing SQL query and stored procedure ?
Answer Posted / vial
stored proceure compiles only once and stores in database
managemant system so it is optimized for best performance
while sql query compiles every time and executes using dbms
driver so its performance decreses
Is This Answer Correct ? | 77 Yes | 21 No |
Post New Answer View All Answers
What is a data source or ds? : sql server analysis services, ssas
Explain the different types of joins?
Which joins are sql server default?
How many servers can we create in a single subscription?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Tell me what is the difference between locking and multi-versioning?
Is natural join and equi join same?
What is sparse columns of sql server 2008?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is CTE in SQL
What are the restrictions applicable while creating views? : SQL Server Architecture
Tell me what is de-normalization and what are some of the examples of it?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
How you provide security to cube? : sql server analysis services, ssas
What is amo? : sql server analysis services, ssas