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
- 12658 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 are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is the purpose of sql profiler in sql server? : sql server database administration
How to convert numeric expression data types using the cast() function?
What stored by the msdb? : sql server database administration
Can a function call a stored procedure in sql server?
What is the cpu pressure?
Do you know nested transaction?
Explain the creation and execution of a user-defined function in the sql server?
What is the difference between substr and charindex in the sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
How to remove duplicate rows from table except one?
What authentication modes does sql server support?
How to edit table in sql server 2017?
What is the difference between a fill factor of 100 and 0?
