Answer Posted / seeman

select * from table_name t1 where (n-1)=
(select count(distinct(t2.column_name)) from table_name t2
where t2.column_name>t1.column_name)

Does view occupy space?

949

---

What is 2nf example?

1000

---

Please illustrate physical database architecture? : SQL Server Architecture

990

---

What are the types of resultset?

967

---

What is the purpose of the model database?

1018

---

What is the recommended total size of your memory optimized tables?

967

---

Can a rule be bound to any column of any data type?

964

---

What is unpivot?

1015

---

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1050

---

Mention the different authentication modes in sql server.

1062

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1082

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

952

---

How to include date and time values in sql statements?

1090

---

Explain boyce and codd normal form(bcnf)?

963

---

What are the 3 types of schema?

1113

---