Answer Posted / abc

we can check for the cpu utilization from the task manager
and if it above 80% then we have to check the status of
indexes or we can say we have to recreate the statics as
well as indexes.
there are many other factors but in production servers
indexing causes a great performance enhancement.Also we
have to check whether large I/o operations are not
hindering the performance.

What happens if we shrink log file in sql server?

909

---

How to download and install microsoft sql server management studio express?

971

---

what is a transaction? : Sql server database administration

932

---

what are different types of raid configurations? : Sql server database administration

993

---

What is the security model used in sql server 2005?

932

---

what are different types of backups available in sql server? : Sql server database administration

889

---

How connect excel to sql server?

928

---

What are the joins in sql server? : sql server database administration

961

---

Explain transaction server consistency?

916

---

What is the new security features added in sql server 2016? : sql server security

1054

---

How to replace null values in expressions using isnull()?

1047

---

Tell about MOM Tool(Microsoft Operator Manager)?

1853

---

How to list all dsn entries on your local machine using odbc_data_source()?

977

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1087

---

What is 'write-ahead log' in sql server 2000 ?

988

---