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
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How to return the top 5 rows from a select query in ms sql server?
What is transact-sql ddl trigger?
How do you improve the performance of a SQL Azure Database?
What are different types of join?
Which joins are sql server default?
what is memory-optimized nonclustered indexes
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What is the difference between a local and a global temporary table?
Explain the dirty pages?
What is the maximum size per database for sql server express?
What is master database? : SQL Server Architecture
What are different types of statement?
Define indexes?
What is subquery explain with example?
