Answer Posted / samar

can u plz give example ,
how to use this data type

What is resource governor?

547

---

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2211

---

Explain about Views?

605

---

List out the differences between the clustered index and non-clustered index in sql server?

505

---

how can you check the level of fragmentation on a table? : Sql server administration

541

---

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

2031

---

last function used in MS Access to convert sql what function will use in sql

1605

---

How to create dbo table in sql server?

516

---

Define Wed Edition in SQL Azure?

80

---

Why we use functions in sql server?

520

---

How do you size a resultset?

501

---

What are the benefits of normalization?

577

---

How to create a local temporary stored procedure?

501

---

What is the synonym of join?

521

---

Do you have any idea about the tcl commands?

553

---