Answer Posted / gautam k panjikar

getdate()

What is a join in sql?

1020

---

How to create new tables with "create table" statements in ms sql server?

1001

---

What causes index fragmentation?

939

---

What is the simplest way to create a new database in ms sql server?

958

---

What is difference between table aliases and column aliases? Do they affect performance?

913

---

How to verify the port number of the sql server?

1042

---

How to create user defined functions with parameters?

1166

---

What is optimistic concurrency?

982

---

What is an identity column in insert statements?

970

---

What are sparse columns?

954

---

What is multilevel indexing?

882

---

Why do we use non clustered index?

1010

---

What is a natural primary key?

952

---

Describe in brief system database.

951

---

Explain the benefits of user-defined functions?

989

---