What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---

What happens if ntwdblib.dll is missing on your machine?

0 Answers  

---

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---

Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 Answers  

---

What is the process of normalization?

0 Answers  

---

What is split brain scenario in DB mirroring?

1 Answers  

---

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

What is an index?

8 Answers   Yardi Software,

---

What information is maintained within the msdb database?

0 Answers  

---