Answer Posted / anilreddy

I am not sure but I do not think there is limit for .ndf files.As needed we can go on adding.

How can sql server instances be hidden? : sql server security

591

---

What is DCL?

585

---

What are extended events in sql server?

500

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

524

---

What is transaction server distributed transaction?

551

---

---

What are the 3 types of schema?

595

---

What is row_number () and partition by in sql server?

516

---

What is spatial and temporal data?

532

---

Explain timestamp datatype?

548

---

Define primary key?

655

---

What should be the fill factor for indexes created on tables? : sql server database administration

622

---

Please illustrate physical database architecture? : SQL Server Architecture

524

---

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

583

---

How do you identify a foreign key?

593

---

What are the reporting services components?

92

---