Answer Posted / swetha

To display current systems date

DateTime.Now

How can we check the sql server version?

1125

---

What happens if null values are involved in datetime operations?

1021

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1085

---

What are the different editions available in sql server 2000?

1112

---

What is database replication? What are the different types of replication you can set up in sql server?

1017

---

What is index fragmentation in ms sql server?

1140

---

What is a partition key?

1030

---

What is a raid and what are different types of raid configurations?

1321

---

What is indexing in sql server with example?

1039

---

What are the character string functions supported by sql server 2005?

1074

---

Where the sql logs gets stored?

1032

---

which backup strategy you are following at ur company

2193

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1020

---

Do you know hot add cpu in sql server 2008?

1002

---

How to delete multiple rows with one delete statement in ms sql server?

1073

---