Answer / Shailendra Kumar Singh

The exact location of a database on the hard disk in MS SQL Server depends on the installation configuration. However, by default, data files have an .mdf extension and log files have an .ldf extension.

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

When do you use SQL Profiler?

3 Answers   Wipro,

---

What is oltp (online transaction processing)?

1 Answers  

---

Accidentally i deleted my table. How can i get that table?

4 Answers  

---

What is a data source or ds? : sql server analysis services, ssas

1 Answers  

---

How to use transact-sql statements to access the database engine?

1 Answers  

---

Do you know what are the reporting services components?

1 Answers  

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

When we can say that is in BCNF?

3 Answers   BitWise,

---

What are commonly used mssql functions in php?

1 Answers  

---

What are the types of user defined functions in sql server?

1 Answers  

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---