Answer Posted / gopi a
Stored Procedure is Precompiled set of quries. Stored
Procedure performence fully depended on this queries. First
Look the queries performence using Execution Plan. After
find the Queries, just check the Index(for table used in
query) and look the join conditions between tables in the
query. - This is way we need to approch to tune the SP.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
How to create function without parameter in sql server?
What are different types of join?
How to provide values to stored procedure parameters in ms sql server?
What are the different normalization forms?
What are the transaction properties?
Why SQL Agent is used?
What is the exact numeric data type in sql?
What is nested transaction?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What is a derived table?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is a non clustered primary key?
Can sql servers linked to other servers?
Explain security with sql azure?
What are the types of indexing?
