Answer Posted / g.ashok

Non clustered index is fast

How to grant a permission in ms sql server using "grant execute" statements?

1071

---

When multiple after triggers are attached to sql table, how to control the order of execution?

1028

---

Define constraints and give an example of their use?

1031

---

What are the basic functions for master, msdb, model, tempdb databases?

1027

---

What is the default value of an integer data type in sql server 2005?

941

---

Can You Use Data Mining Models In Ssrs?

145

---

How to drop an existing table with "drop table" statements in ms sql server?

1068

---

How to enter binary string literals in ms sql server?

1131

---

What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

1123

---

What is indexing and its types?

1003

---

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

1044

---

What are the two authentication modes in sql server?

1100

---

What is transact-sql language?

1059

---

Create and insert into temp table in sql server?

1009

---

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1023

---