What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

---

What is a database table?

0 Answers  

---

How do you create an execution plan?

0 Answers  

---

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

---

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

---

---

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

0 Answers  

---

What are the restrictions while creating batches in sql server?

0 Answers  

---

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

How to use transact-sql statements to access the database engine?

0 Answers  

---