Answer Posted / 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
)

Which are the new data types introduced in sql server 2008?

889

---

What are scalar functions?

1006

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1203

---

How to send a ssrs report from ssis?

179

---

Explain activity monitors

1085

---

Does full backup break log chain?

974

---

Why do you want to join software field as you have done your BE in Electronics?

2151

---

How to create a new table in a given schema?

1196

---

what is the difference between Tabular and Matrix report?

173

---

Explain the properties of a relational table?

1030

---

How do I save a stored procedure in sql server?

1008

---

Difference between Sql server reporting services and Crystal reports?

172

---

What is difference between commit and rollback when used in transactions?

970

---

Can we install sql server 2016 on windows 7?

1145

---

How to perform key word search in tables?

966

---