Answer Posted / vimal

dbcc traceon 302

How to connect to SQL Azure Database by using sqlcmd?

136

---

How do I find the sql server database version?

942

---

Explain hostprotectionattribute in sql server 2005?

961

---

What is a view and what are its advantages?

1055

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

901

---

ow to bring suspect mode datbase online from scratch

1763

---

How will you add a dimension to cube? : sql server analysis services, ssas

1013

---

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

859

---

What is row_number () and partition by in sql server?

1007

---

What is difference between materialized view and view?

879

---

How to write an inner join with the where clause in ms sql server?

1034

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

915

---

What is the difference between Triggers and Stored Procedure?

1033

---

What is field in algebra?

983

---

What is the sql server agent?

1034

---