Answer Posted / velmurugan,uk

There are many differences interms of
1.Architecture,
2.Services,
3.Performance,
4.Scalability,
5.Design and Deployment application,
6.Tools
and so on...

List some of the rules that apply to creating and using a ‘view’

859

---

Which is faster statement or preparedstatement?

917

---

What is a collation in ms sql server?

1055

---

How to start and end transact-sql statements?

1002

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

961

---

List out the difference between union and union all in sql server?

969

---

What is log in sql server?

1123

---

What is scalar user-defined function?

1073

---

How to enforce security in sql server? : sql server security

1075

---

What is nonclustered index on computed columns?

937

---

What are the advantages of using stored procedures in sql server?

995

---

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., }

2317

---

Can you explain various data region available in ssrs with their use?

959

---

What is the definition for sql server 2000?

1073

---

State the difference between union and union all?

915

---