Answer / Md Hasan Ahmad

A SQL Server database can contain multiple files, including primary data files (.mdf), secondary data files (.ndf), and log files (.ldf). A single database can have one primary data file but an unlimited number of secondary data files. It must have at least one primary data file and one log file.

What are the types of resultset?

1 Answers  

---

Explain the microsoft sql server delete command? : SQL Server Architecture

1 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

1 Answers  

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1 Answers  

---

What is the difference between row_number and dense_rank?

1 Answers  

---

What are the types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

How can you fetch alternate records from a table?

1 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed?

1 Answers  

---

What is the default schema of your login session in ms sql server?

1 Answers  

---

what is raid? : Sql server database administration

1 Answers  

---

How can I create a report based on a query? : sql server management studio

1 Answers  

---