Answer / j.jyothy

Filegroup is a logical container for the collection of
datafiles.(.mdf or .ndf that is primary file group or
secondary file group)
Every database contain 2 file groups
1.Primary file group, which Contains all the primary data
files any other Secondary datafile which is not
specifically allocated to anyother file groups
2.User defined file group:It is created by the user to
group the datafiles

3.transaction log file:Does not belong to any file group.A
database can have maximaum of 32,767 file groups

Example:
Create database student
on Primary ***Primary
(
name='student_pri_data1.mdf',
filename='g:\student_primary_data1.mdf',(Location of this
file group)
size=2mb
maxsize=10mb
filegrowth=1mb
),
filegroup student_group1 ***Secondary
(
name='student_Sec_data1.mdf',
filename='g:\student_sec_data1.mdf',(Location of this file
group)
size=10mb
maxsize=12mb
filegrowth=2mb
)
log on ***log file
(
name='student_log_data1.mdf',
filename='g:\student_sec_data1.mdf',(Location of this file
group)
size=12mb
maxsize=10mb
filegrowth=1mb
)

Answer / priyanka

Filegroups are named collections of files and are used to
help with data placement and administrative tasks such as
backup and restore operations.

Answer / anuj

Filegroups are group or collection of Files that is used to
maintauined the transaction of Data and Restore Operations.

Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,

---

Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

---

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

What is trigger and different types of Triggers?

0 Answers   QuestPond,

---

Is it true, that there is no difference between a rule and a check constraint?

0 Answers  

---

What is primary key index?

0 Answers  

---

What are the types of sql server?

0 Answers  

---

What is shrink log file?

0 Answers  

---

What are temporal tables in sql server 2016?

0 Answers  

---