Answer / hari

first you rebuild the master db by using REBUIDM.exe. after
u take single user mode Sqlservr.exe -c -m.

Which is the latest version of sql server and when it is released?

0 Answers  

---

Write a SQL Query to find first Week Day of month?

2 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

Explain the difference between functions and stored procedures in sql server?

0 Answers  

---

What is buffer cash and log cache in sql server?

0 Answers  

---

Explain the difference between clustered and non-clustered index?

0 Answers  

---

What is normalization and what are the advantages of it?

0 Answers  

---

how many type of subquery?

2 Answers  

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---

What is the difference between for xml raw and for xml auto?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

Do you know what is blocking?

0 Answers  

---