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
- 12976 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
Explain a checkpoint?
What is for xml in sql server?
Which are the olap features?
What is Transparent Data Encryption?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is difference between createstatement and preparedstatement?
What are the types of sql server?
What are the different types of cursor?
What kind of problems occurs if we do not implement proper locking strategy?
What does set rowcount do?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain what is lock escalation?
Create and insert into temp table in sql server?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What is best institute to Learn DotNET And SQL in chennai?
