Answer Posted / 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 are the different ways to return the rowcount of a table?

945

---

How to provide values to stored procedure parameters in ms sql server?

976

---

Do you know what guidelines should be followed to help minimize deadlocks?

922

---

What’s the use of custom fields in report?

892

---

How to use union to merge outputs from two queries together in ms sql server?

1011

---

What is difference between equi join and natural join?

970

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8109

---

What is reportserver and reportservertempdb ?

143

---

What part does database design plays a role in performance of an sql server-based application?

928

---

Can we deploy SSRS reports on our personal website?

162

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

1940

---

Explain a checkpoint?

976

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2266

---

What is sub-query in sql server? Explain its properties.

1043

---

What is sql server query analyzer?

967

---