Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / arun yadav
There could be 'n' reasons for slow performance. For tuning
the performance of a SP we need to know how much resources
it is using and how much time it takes in execution. We can
check this using the performance monitor (for example, RPC
Counter) and execution plan. Check if we are using
appropriate joins, table defrag, index rebuilt can be the
solutions.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What is openrowset sql server?
How many partitions a clustered index has by default in sql server 2012?
What is the difference between substr and charindex in the sql server?
what is unique and xaml nonclustered index
What is transaction server consistency?
Explain ranking functions?
What is a linked server in sql server?
What are different types of table joins?
What is the default sql server instance name?
Where do you find the default Index fill factor and how to change it?
What is normalization? Explain its different types?
Tell me what do we need queues in sql service broker?
What is a mixed extent?
What are the different authentication modes in sql server? How can it be changed?
