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
- 10591 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
What is Sqlpaging in SqlServer 2005 ?
What is the difference between count () and rowcount ()?
Using the customer, and order table in northwind database, please write a query to produce xml?
What is spatial and temporal data?
Explain some stored procedure creating best practices or guidelines?
What is update locks?
What is scrollable cursor?
What have included columns when we talk about sql server indexing?
How can I change procedure name in sql server?
What are the dmvs?
What is a covered index?
How do I find the sql server database version?
How to add more data to the testing table in ms sql server?
How do you start single user mode in clustered installations?
What is the purpose of the tempdb database?
