Answer / Sapana Verma

SQL Native Client is a set of drivers provided with Microsoft SQL Server that allows applications written in .NET, Java, or ODBC to connect to the SQL Server Database Engine.n
1. Key Benefits: Offers better performance, scalability, and reliability compared to earlier versions like ODBC Driver 11.n
2. Components: Consists of SQL Native Client Redistributable, which includes essential files for connecting to SQL Server, and the Management Objects (SMO) and Reporting Services (RS) components for management and reporting tasks.n
3. Connection Pooling: Supports connection pooling to minimize the overhead of establishing connections.

What are the source of constraints?

0 Answers  

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1 Answers  

---

Explain boyce and codd normal form(bcnf)?

1 Answers  

---

Explain try...catch with sql server?

1 Answers  

---

What is Online Index Rebuild Operation?

1 Answers  

---

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1 Answers   CSC, IBM,

---

Can we use pragma autonomous_transaction in trigger?

1 Answers  

---

When columns are added to existing tables, what do they initially contain?

1 Answers  

---

Why transaction is important?

1 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---

Do you know what is a with(nolock)?

1 Answers  

---

How to write a query with a full outer join in ms sql server?

1 Answers  

---