Answer / Bhoop Singh

To optimize a slow-running SQL Server job, consider the following actions:
n 1. Indexing: Ensure that proper indexes are created on frequently queried tables to speed up data retrieval.
n 2. Query Optimization: Review and optimize your queries to minimize resource usage. This includes using appropriate joins, filters, and limiting the amount of data returned.
n 3. Statistics: Create or update statistics for tables to help the query optimizer make better choices when executing queries.
n 4. Plan Cache Management: Monitor and manage the plan cache to reduce memory usage and improve performance.
n 5. Query Store: Use SQL Server's Query Store feature to analyze past query execution history, store query plans, and automatically choose the best performing query plan.

Write down the syntax and an example for create, rename and delete index?

1 Answers  

---

Can you explain about buffer cash and log cache in sql server?

1 Answers  

---

Explain the difference between function and stored procedure?

1 Answers  

---

What is update locks?

1 Answers  

---

How is a full-text index updated?

1 Answers  

---

What do you understand by user-defined function in the sql server?

1 Answers  

---

what command is used to create a table by copying the structure of another table?

7 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

Explain an automatic checkpoint

1 Answers  

---

How to use wildcard characters in like operations in ms sql server?

1 Answers  

---

How you can add messages to the nt event log from within a stored procedure?

1 Answers  

---

How would you Update the rows which are divisible by 10, given a set of numbers in column?

3 Answers  

---