Explain what are page splits? : SQL Server Architecture

0 Answers  

---

Explain nested trigger in sql?

0 Answers  

---

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

How to write an inner join with the where clause in ms sql server?

0 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

What are the recovery models for a database?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

Can I save my report as html, excel or word? : sql server management studio

0 Answers  

---

Relational calculus is what type of language?

0 Answers   HCL,

---

What is #temp and @table variable in SQL server?

0 Answers  

---

What is normalization 1nf 2nf 3nf?

0 Answers  

---