Answer Posted / lalit

shift+space bar

What are window functions in sql server?

1004

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

944

---

Explain user defined views?

957

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1590

---

What is a partition function in sql server?

1131

---

What do you understand by the analysis services in sql server?

939

---

What is a DBMS, query, SQL?

1046

---

How does index makes search faster?

972

---

What is the difference between createstatement and preparedstatement?

938

---

What is replication with database mirroring? : sql server database administration

1072

---

Do you know clustered and non-clustered index?

977

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1114

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1120

---

How to include date and time values in sql statements?

1083

---

What is inner join? Explain with an example?

1215

---