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
- 12951 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 reporting services components?
Tell me what is the significance of null value and why should we avoid permitting null values?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How to change a login name in ms sql server?
Difference between DELETE and TRUNCATE?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
When I run the sql server 2000 setup, it just hangs. What do I do?
Is foreign key unique?
What is difference between rownum and rowid?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is “asynchronous” communication in sql server service broker?
How to delete an existing row with delete statements in ms sql server?
What are .mdf files?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What are indexes in sql?
