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
- 11493 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
in the physical file layout, where should the transaction log be stored in relation to the data file?
How to locate and take substrings with charindex() and substring() functions?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
what's the difference between delete table and truncate table commands? : Sql server database administration
Write a program using SQL queries to find a unique entry in a table.
Can a unique index be created on a column, which contains null?
How to get a list of columns in a view using the "sp_help" stored procedure?
Explain difference between cross join and full outer join?
What is the difference between a clustered index and a non-clustered index?
Why use sub query in sql server and list out types of sub queries?
How do I view a stored procedure in sql server query?
What are the differences between stored procedure and the dynamic sql?
Why would you use sql agent?
Explain about nested stored procedure?
What is triggers in ms sql server?
