Answer / Nakul Srivastava

{"Using SELECT @@VERSION; command in SQL Server Management Studio (SSMS). The output will display the Service Pack level along with other details."}

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

How to get the number of affected rows?

1 Answers  

---

What is a mixed extent?

1 Answers  

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

1 Answers  

---

How to set a database state to offline in ms sql server?

1 Answers  

---

Explain some DBCC commands?

6 Answers  

---

What is 1nf 2nf?

1 Answers  

---

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1 Answers  

---

Explain active/passive and active/active cluster configurations?

1 Answers  

---

Does a full backup include transaction log?

1 Answers  

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

How to create user messages with print statements in ms sql server?

1 Answers  

---