Answer / Raju Kumar Rai

In SQL Server 2000, there are five system databases and one user-created database file:n
1. Master: Stores metadata about other databases, login information, and system objects.
2. Model: Contains the default settings for a new database.
3. Tempdb: Temporary storage area for sorting, hash tables, and worktables during execution of queries.
4. Msdb: Used by SQL Server Agent to store job history, alerts, and other agent-related objects.
5. Northwind: A sample database that contains data from an online food sales company.

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1 Answers  

---

What are the advantages of using views. Why do we need views when we have SPs?

4 Answers   247Customer,

---

Does partitioning improve performance sql server?

1 Answers  

---

Why do we partition data?

1 Answers  

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

What does asynchronous call backs means?

1 Answers   Alcatel-Lucent,

---

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

---

Explain system functions or built-in functions? What are different types of system functions?

0 Answers  

---

How to define and use table alias names in ms sql server?

1 Answers  

---

What is Schema? and why we use schemas?

4 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

What is a database table?

1 Answers  

---