Answer / Om Prakash Bharti

"PowerShell" is a scripting language and automation framework that is integrated into SQL Server 2008. PowerShell allows database administrators to perform tasks more efficiently by automating repetitive tasks, configuring servers, managing data, and monitoring performance. The integration of PowerShell with SQL Server provides a powerful tool for managing SQL Server environments.

Explain the phases a transaction has to undergo?

1 Answers  

---

can we call functions from stored procedure in SQL Server 2005 ? How?

3 Answers  

---

How to create a store procedure with encryption?

1 Answers  

---

What is a NOLOCK?

3 Answers   NA,

---

What happens when transaction log is full?

1 Answers  

---

What is read committed?

1 Answers  

---

What is CTE in SQL

1 Answers   Infosys,

---

What is 1nf 2nf?

1 Answers  

---

What are the difference between “where” and “having” clause in sql server?

1 Answers  

---

How to transfer a table from one schema to another?

1 Answers   MCN Solutions,

---

Anyone please explain me the concept of Serialization?

3 Answers  

---

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

---