Answer Posted / ivreddy

Basically 2 tier architecture : This has 2 parts namely
client (front
end) and database (back end).The window application
generally developed in this technology

3 tier architecture :
1 Client-front end (request is given through client)
2.business logic :Middle layer (protocols are used for
processing the request)
3. Database :back end (response is given to the client)
Web applications are good examples for 3 tier architecture
The above answer ,i found in one of the sites.

How does index makes search faster?

918

---

Find columns used in stored procedure?

934

---

when you create a database how is it stored? : Sql server database administration

939

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1453

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1001

---

State the difference between union and union all?

889

---

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

916

---

What are various aggregate functions that are available?

913

---

Can a database be shrunk with users active?

1062

---

What is cte (common table expression)?

976

---

How can I add Reporting Services reports to my application?

125

---

What is transact-sql ddl trigger?

1043

---

What are data files?

981

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

944

---

What are the differences between stored procedure and the dynamic sql?

1022

---