Answer Posted / hari

Sql Server is having Physical database and logical database
in physical database-Filegroups,transcation log
Filegroups contains - datafiles
datafiels contains - tables
tables contains - Extents
Extents contains - pages
Pages contains - Rows
Trancastion log is user defined file group by default it is
primary file group,
Logical database objects like
storedprocedre,views,indexes,trigeers

What is sql server profiler trace data file?

1100

---

How to use "begin ... End" statement structures in ms sql server?

1028

---

Is the order of columns in the set clause important in ms sql server?

964

---

Explain throw statement in sql server 2008?

982

---

What is in place upgrade in sql server?

1035

---

How to retrieve error messages using mssql_get_last_message()?

1040

---

List some major differences between triggers and stored procedures?

903

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1251

---

Tell me can we use custom code in ssrs?

995

---

Which Model uses the SET concept

980

---

What is code near application topology?

279

---

What do you do in data exploration

983

---

What Is Rdbms?

1145

---

What is partition in sql server?

1031

---

Please explain go command in sql server?

1042

---