Answer Posted / khalid moin

try to use function based indexes and use it when needed..
it will not be used unnecessorily.

use clustering concept while creating table it will make you
join operation fast if more join operation u r going to
perform on the tables

Why the trigger fires multiple times in single login?

1204

---

what happens on checkpoint? : Sql server database administration

1093

---

Explain the creation and execution of a user-defined function in the sql server?

1047

---

What is the function of sql server agent windows service?

1089

---

How do you delete duplicate rows in sql server?

955

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

963

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

1985

---

How to list all field names in the result set using mssql_field_name()?

912

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

1000

---

What is implicit mode in sql server?

1101

---

what are the disadvantages of cursors? : Sql server database administration

1029

---

What is multi-statement table-value user-defined function?

991

---

Explain the concepts and capabilities of sql server?

969

---

List the various tools available for performance tuning?

887

---

What is schemabinding a view?

918

---