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
- 12745 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
List some of the rules that apply to creating and using a ‘view’
What is normalization? Explain different forms of normalization?
How to convert a table data in XML format in sql server?
How to create new tables with "select ... Into" statements in ms sql server?
What is the default server name for sql server?
Do you know what is similarity and difference between truncate and delete in sql?
What is the importance of three tier architecture?
Where are SQL server users names and passwords are stored in sql server?
What is data source object?
Explain what are sparse columns?
How to provide default values to function parameters?
What will happen if a column containing char type data is changed to the nchar data type?
What extended events?
What is the difference between functions and scalar functions?
How would you add a section to a table?
