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

define and explain the differences between clustered and non-clustered indexes.

0 Answers   Microsoft,

---

What is an execution plan? How would you view the execution plan?

0 Answers  

---

Can we call future method from trigger?

0 Answers  

---

What is the use of sign function?

0 Answers  

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

what is joins please explain breffly ??

1 Answers   Adaequare, TCS,

---

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

---

if no size is defined while creating the database, what size will the database have? : Sql server administration

0 Answers  

---

What is microsoft sql server?

0 Answers  

---

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

---