Where is my database stored on the hard disk in ms sql server?

0 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

What is self join in sql server joins?

0 Answers  

---

What is blocking?

0 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

0 Answers  

---

How reterive duplicate value in SQL?

6 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

Explain what is lock escalation and what is its purpose?

0 Answers  

---

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  

---

WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.

1 Answers   Synergy,

---

what is the main difference between after trigger and instead trigger.

2 Answers  

---