Answer / Amarjeet Kumar Paswan

A file group in SQL Server is a logical container for one or more database files. It helps manage and organize data across multiple files, improving performance and storage flexibility.

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1 Answers  

---

What is 'Join' and explain its various types.

1 Answers   Genpact,

---

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

---

What is data modification?

1 Answers  

---

What is query and its types?

1 Answers  

---

Can store procedure call by user define function in SQL server?

10 Answers   HCL,

---

Explain ms sql server reporting services vs crystal reports?

1 Answers  

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

1 Answers   IBM,

---

You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?

1 Answers  

---

What is the difference between a view and a stored procedure?

1 Answers  

---

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1 Answers  

---

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

1 Answers  

---