Answer / Gulwaiz Akhter

Indexing in SQL Server involves creating an additional data structure to speed up the retrieval of rows from a table. An index contains one or more columns of the table's data and can be used to locate specific rows quickly, especially when searching for values based on the indexed column.

What is the difference between a function and a trigger?

1 Answers  

---

What do you understand by replication in sql server?

1 Answers  

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

1 Answers  

---

Give an example of SQL injection attack ?

1 Answers   HAL,

---

1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?

10 Answers   Perot Systems,

---

Can group functions be used in the order by clause in ms sql server?

1 Answers  

---

How to get a list of all tables with "sys.tables" view in ms sql server?

1 Answers  

---

Can you explain different types of locks in sql server?

1 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

1 Answers  

---

Explain rdbms?

1 Answers  

---

What is sql profiler. What are the default templates with it? : sql server database administration

1 Answers  

---

Does partitioning improve performance sql server?

1 Answers  

---