How to find index size for each index on table?

0 Answers  

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

Explain what is scheduled job and how to create it?

0 Answers  

---

What is lock escalation?

1 Answers  

---

Explain full-text indexing?

0 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

What is Check point? Explain in Brief what it will do?

1 Answers   Wipro,

---

Can you roll back the ddl statement in a trigger?

0 Answers  

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

find 2nd highest salary of person using cursor concept?

6 Answers   HCL,

---

What is a heap?

0 Answers  

---

How do you drop an index?

0 Answers  

---