Answer Posted / a

int

Tell me what is the difference between locking and multi-versioning?

1021

---

How to delete an existing row with delete statements in ms sql server?

1087

---

What is a transact-sql statement?

1050

---

how to do partition in sqlserver

2465

---

What is sql server profiler trace data file?

1106

---

According to you what goes into making the best database administrator? : sql server database administration

974

---

Why I am getting this error when dropping a database in ms sql server?

1072

---

Describe how to use linked server?

1009

---

How do you send email on SQL Server?

1055

---

What is the difference between index seek vs. Index scan?

1021

---

Can we check locks in database? If so, how can we do this lock check?

937

---

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1081

---

How can I tell if sql server is 32 or 64 bit?

951

---

What is named query? : sql server analysis services, ssas

958

---

Where the sql logs gets stored? : sql server database administration

960

---