Interested to Buy Any Domain ? << Click Here >> for more details...
1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication?
- 7 Answers
- 12901 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / koti-khammam
3) ANS: There are a number of common reasons for slow-
running queries and updates:
Slow network communication.
Inadequate memory in the server computer, or not enough
memory available for SQL Server.
Lack of useful statistics on indexed columns.
Out-of-date statistics on indexed columns.
Lack of useful indexes.
Lack of useful indexed views.
Lack of useful data striping.
Lack of useful partitioning.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How to loop through returning rows?
What is the difference between commit and rollback?
Why do we use stored procedures in sql server?
Define left outer join?
What is store procedure? How do they work?
What is the significance of master, tempdb and model databases?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
What is implicit cursors?
what are acid properties? : Sql server database administration
How to change server name in sql server?
What do you understand by physical_only option in dbcc checkdb?
Do I need a report server to run reports in my application?
What is the cpu pressure?
What is the return type of executeupdate ()?
What does indexation mean?
