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?
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 do users use Report Builder with SQL Server data sources?
What are magic tables in sql server?
What is a transact-sql statement batch in ms sql server?
What is a transaction and why is it important?
Explain hostprotectionattribute in sql server 2005?
Explain the advantages of merge replication?
What is exclusive locks?
What is use of @@ spid in sql server?
When does a workload on SQL Azure get throttled?
Explain syntax for viewing, dropping and disabling triggers?
Is the primary key column of a table an index in ms sql server?
How to create a trigger for insert only?
what is unique and xaml nonclustered index
How do you clear a log file?
What gets stored inside msdb database?