Answer Posted / manub22

- CTE
- APPLY OPERATOR (CROSS, OUTER)
- OVER CLAUSE with PARTITION BY
- RANKING FUNCTIONS
- PIVOT & UNPIVOT
- Synonyms

Check here all new features in SQL Server 2005: http://sqlwithmanoj.com/category/sql-server-versions/sql-server-2005-sql-server-versions/

What are sql dirty pages?

1012

---

What is the purpose of self join?

966

---

What are partitioned views and distributed partitioned views?

1015

---

What is correlated subquery in sql server?

1058

---

What are different types of statements that are supported by sql?

1033

---

What are approximate numeric data types in ms sql server?

1046

---

How can you find out which stored procedures are recompiling?

914

---

Write a program using SQL queries to find a unique entry in a table.

982

---

What is a view in sql?

968

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1138

---

What is a non clustered primary key?

917

---

What are relationships and mention different types of relationships in the dbms

958

---

Explain primary key in sql server?

1009

---

How do I manually uninstall an instance of sql server 2016?

1022

---

How to transfer data from a cursor to variables with a "fetch" statement?

1082

---