Answer / Rahul Shankar

"TempDB in SQL Server is a system database that stores temporary objects (tables, indexes, etc.) and work tables used by various components of SQL Server. It provides a place for SQL Server to store intermediate results during query execution, sorting operations, and other internal processing."

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

1 Answers  

---

Explain about temporary stored procedure?

1 Answers  

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

1 Answers  

---

Explain filtered indexes?

1 Answers  

---

What happens if you delete a table that is used by a view?

1 Answers  

---

How to use go command in "sqlcmd"?

1 Answers  

---

What are built in functions?

1 Answers  

---

Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,

---

syntax for deleting the database in T SQL

5 Answers  

---

Explain sub-query?

1 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

What is mean by candidate key?

1 Answers  

---