Answer Posted / sirisha

Batch is nothing but a set of sql statments that are
executed at time (all the stmts will be exceuted or none(if
any error encountered))

eg:
use [database]
GO
select empname from employee
insert employee(empno,empname)
select empno =1
,empname ='A'
GO

What are the different kinds of ssrs reports?

214

---

Which is better statement or preparedstatement?

922

---

How to make remote connection in database?

1002

---

What is raid, and how it can influence database performance?

1051

---

What is an indice?

1025

---

How to provide values to user defined function parameters?

1006

---

When we should use and scope of @@identity?

995

---

What is the security model used in sql server 2005?

998

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1961

---

What is difference between cte and view?

907

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

904

---

What does <> symbol mean?

961

---

What are the types of indexing?

1076

---

What is policy management?

990

---

How to restore performance issues and how to check?

1997

---