Answer Posted / laxman

Login is to connect sql server & user is connect individual
db in server.
every db user will maped with login.

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1174

---

What do you mean by the term 'normalization'?

1282

---

Difference between Inner vs outer joins?

988

---

Describe triggers features and limitations?

1054

---

How to add a new dsn with the odbc driver for sql server?

1112

---

Mention what are the core components of ssrs?

330

---

Why do we need different type of parameter?

1108

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1087

---

Explain about Views?

1125

---

how you can configure a running aggregate in SSRS?

199

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1090

---

What is checkpoint in sql server?

1216

---

What do you understand by physical_only option in dbcc checkdb?

1024

---

What are trace flags?

1086

---

How to find out what is the default collation in a database?

1179

---