Answer / sqldba29

Trace flags are used to temporarily set specific server
characteristics or to switch off a particular behavior. For
example, if trace flag 3205 is set when an instance of SQL
Server starts

1204: Deadlock information

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

---

What is an example of a primary key?

0 Answers  

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

What is user defined datatypes and when you should go for them?

0 Answers  

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

Distinguish between commit and rollback?

0 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

wht is normalization?can u explain me in detail?

9 Answers   TCS,

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

Detail about query optimizer?

0 Answers  

---