Answer / Mohit Singhal

In SQL Server, the JOIN clause allows you to combine rows from two or more tables based on a related column between them. This helps in retrieving data that spans multiple tables while maintaining their relationship.

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1 Answers  

---

Can we return Data from 4(more than 1) tables in stored procedure?

1 Answers   HCL,

---

What are the properties of primary key?

1 Answers  

---

What is normalization and its types?

1 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1 Answers   iSoft,

---

How to change the system date and time from SQL Plus Terminal ?

1 Answers   MCN Solutions,

---

How do you rebuild an identity column?

1 Answers  

---

Explain the first normal form(1nf)?

1 Answers  

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

---

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

1 Answers   Cognizant, HCL, Value Labs,

---

How to filter out duplications in the returning rows in ms sql server?

1 Answers  

---