Answer Posted / rajkumar v

select convert(varchar,getdate(),105)

How do I setup a sql server database?

544

---

Which is better statement or preparedstatement?

518

---

How to stop log file growing too big?

572

---

Please illustrate physical database architecture? : SQL Server Architecture

526

---

How do indexes help, types?

548

---

---

Define clusters?

643

---

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

632

---

Explain the architecture of ms sql reporting service?

526

---

What are the components of sql server service broker?

507

---

What is sql server query analyzer?

504

---

SQL Server Architecture ?

1923

---

Explain acid?

604

---

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

528

---

How to recover from sql injection? : sql server security

520

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

517

---