Answer / pradeep

Schema is a logical set of data. It contains tables, views,
Packages, constraints. This is treated as a whole database.
This has assigned with a unique id called as SID i.e.
System ID. Because of this ID one can create n number of
DBs on a single DB server. Obviously within the limit of
the hardware of DB server.

What is field with example?

0 Answers  

---

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

Explain DBCC?

0 Answers   QuestPond,

---

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

---

Is mysql better than sql server?

0 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

Is INSTEAD OF trigger directly applicable to Table ?

0 Answers  

---

Can a table be moved to different filegroup?

0 Answers  

---

Explain how does the report manager work in ssrs?

0 Answers  

---

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

---

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

---

System requirements for sql server 2005 express edition?

0 Answers  

---