Answer Posted / rajkumar

select getdate()

Why union all is faster than union?

906

---

Explain error and transaction handling in sql server?

1005

---

How to create a ddl trigger using "create trigger" statements?

1119

---

What are the steps to take to improve performance of a poor performing query? : sql server database administration

1030

---

What are the disadvantages of using the stored procedures?

1094

---

Can we hide the definition of a stored procedure from a use?

1214

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

954

---

How do clustered indexes store data?

1096

---

What happens when unicode strings concatenate with non-unicode strings?

1079

---

What are user-defined functions (udfs) in sql server?

981

---

How to drop an existing schema in ms sql server?

1090

---

What are the built in functions in sql server?

976

---

What is the primary use of the model database?

1079

---

What do you understand by hotfixes and patches in sql server?

978

---

How will you hide an attribute? : sql server analysis services, ssas

952

---