Answer Posted / kumar

Batch in Sql server is a set of one or more Transact-SQL
statements sent from a client to an instance of SQL Server
for execution and it will represents a unit of work
submitted to the Database Engine by users.

Which language is supported by sql server?

951

---

What is a performance monitor?

916

---

What are wait types?

1010

---

What is perspective, have you ever created perspective? : sql server analysis services, ssas

856

---

What is difference between view and materialized view?

885

---

Is the primary key column of a table an index in ms sql server?

915

---

Do you know what are pages and extents? : SQL Server Architecture

935

---

How to declare and use cursor variables?

1072

---

What is the default value of an integer data type in sql server 2005?

909

---

What is cdc in sql server?

948

---

What is sql profiler. What are the default templates with it? : sql server database administration

949

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1005

---

What is proper subset of candidate key?

944

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

887

---

What functions can a view be used to performed?

988

---