Answer Posted / shivangi

Select max(Salary) from employeetable where salary < (select
max(salary) from Employeetable)

Why use sub query in sql server and list out types of sub queries?

936

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

849

---

can you instantiate a com object by using t-sql? : Sql server database administration

960

---

What is database replication? What are the different types of replication you can set up in sql server?

911

---

What is difference between global temporary tables and local temporary tables?

1175

---

What is tabulation?

896

---

How much memory that we are using in Logshipping Concept?

1726

---

What is exporting and importing utility?

1016

---

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

890

---

How to create a Master database in SQL server ?

1016

---

Explain few of the new features of sql server 2008 management studio

858

---

How does normalization work?

864

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

843

---

What are the properties of the relational tables?

828

---

What are the requirements on sql server network connections?

896

---