Answer Posted / vimal

Select Replace('""','""',Char(39)+Char(39))

you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration

1028

---

How does normalization work?

972

---

What is sql server query analyzer?

1098

---

What are the difference between “where” and “having” clause in sql server?

1131

---

How to attach adventureworkslt physical files to the server?

1160

---

What are tables in sql server?

1097

---

Which language rdl files made of?

141

---

Explain user defined functions?

1046

---

What is sub-query in sql server?

1259

---

Can sql server be linked with other servers like oracle?

1022

---

Can group functions be used in the order by clause in ms sql server?

1067

---

What is the use of stored procedure?

980

---

What happens if null values are involved in boolean operations?

1043

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1135

---

Difference between Sql server reporting services and Crystal reports?

175

---