server side code vs clientside code ?

Server side code executes on the server.

Authenitication & Authorization

Explain Localization & Globalization ?

Benifits and Limitations of Query String ?

What is a Query String ?

Benifits and Limitations of cookie ?

What is a cookie ?

Cookie is a piece of information stored in the client computer/Browser which is limited to 4k in size.

Advatanges:-

1.  very simple to implement
2. Browser automatically arranges cookies stored for multiple sites

Disadvantages:-

1. It stores cookie data in simple text format,so its not secure.
2. cookie size limited to 4 kb
3. No. of cookies stored by browser are limited to 20.some allow 300,when a new cookie comes old one will be discarded,

There are 2 types of cookies

• Non-persistent(Temporary) cookies
• Persistent(Permanent) cookies

What is Caching ?

What is View State ?

View State is a technique used by asp.net webpage to persist changes to state of a webform between postbacks.

View state of page is by default stored in hidden form field named _viewstate.

ADVANTAGES:- 

• Automatic retention of page and control state
• server resources not required.(View state can also be stored in server side.)
• The values in view state are compressed and hashed

DISADVANTAGES:-

• view state increases the page size since it is stored in the page itself.
• Although view state stores data in hashed format they can be tampered.

What is the advantage of SET NOCOUNT ON ?

• Use Nocount at the begining of all your Stored procedures,Functions and Triggers

In case of regular T-sql statements(Insert,Update,Delete,Select) execution, we observe a message like some 20(rows) affected in the result window.This is actually a message database return internally to the client.This costs our application in terms of performance because information is sent back to us(client).

This intensifies when we have many operations(Insert,Update,Delete) in a stored procedure.That means each operation returns internal message within the stored procedure execution cycle.

Difference between Serialization & DE-Serialization ?

What is Serialization ?

Difference between ADO & ADO.Net ?

Difference between Data Reader & Data Set ?

Data Set ?

Data Adapter

Data Reader

LIKE Statement ?

Explain Drop Query ?

TRIGGERS ?