What is the difference between UNION and UNION ALL ?

Friday, March 11, 2011

Union returns distinct values,unionall returns all values.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is WAS Tool?

Web Application Stress ( WAS ) tool, simulates multiple HTTP clients making requests to your Web site, while ASP.NET includes a number of performance counters that you can use to track the execution of your application.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #58 - Better Global.asax

create a custom base class for the Global.asax file. This base class inherits from the HttpApplication class, just like the default Global class that sits behind the Global.asax file. The custom base class provides the same members as the default Global.asax file, but even better, you can extend the class with additional members, such as custom properties for tracking counters.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Name any popular IP Redirector?

Cisco’s LocalDirector or F5 Network’s BIGIP.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Will ACT provide HTTP Errors Count?

Yes.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is TCA?

Transaction Cost Analysis (TCA), provides a quantitative measure of the processing cost of your application for a specific user load.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is TTLB?

This counter measures (in milliseconds) how long it takes for the Web application to service a request. TTLB is a key
indicator of how scalable an application is.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is the expansion of TTLB?

Time to Last Byte.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is ACT?

Application Center Test (ACT), is a stress test tool for Web applications.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is the expansion of ACT ?

Application Center Test


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

How will you start Asp.net State Service?

Start >Programs > Administrative Tools > Services > ASP.NET State Service


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #57 - Background Processing

Use background processing on suitable situations. Use Timer class, found in the System.Threading namespace.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #56 - Connection Pooling

Avoid repeatedly connecting to the database , instead use Connection Pooling.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #55 - Avoid unnecessary Boxing and Unboxing

Use generics collection as compared to simple collection , to avoid boxing / unboxing.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #54 - DB Coding in Application

Use as much of Stored Procedure as you can instead of queries inside the application. By this the execution happens at the backend and only results are returned thereby increasing performance and speed.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Daily Tips- Tip #53 - String concatination

Use StringBuilder for string concatination instead of String


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Which one is faster Hashtable or Dictionary?

Dictionary is faster than Hashtable.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What are the most popular naming conventions ?

Pascal , Camel and Hungarian


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What does the Substitution Control does?

The Substitution control specifies a section on an output-cached Web page that is exempt from caching.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Does Post Cache Substitution disables dynamic Caching?

Yes. It dynamically disables public (or client) caching and switches the page to use server caching. This is because the substitutions need to happen via server-side logic.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

How will you implement Post Cache Substitution?

It can be implemented in 2 methods:
1. Call the new Response.WriteSubstitution method, passing it a reference to the desired
substitution method callback.
2. Add a control to the page at the desired location, and set its
methodName attribute to the name of the callback method.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is Post Cache substitution?

It implements a dynamic region within a cached page.
Ex: In AdRotator entire page will be cached but a new ad will be displayed on every request.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

Can we post and access view state in another application?

If you post to other applications, PreviousPage property will be null.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

How can i get all the objects in Cache?

The following statement fetches all the objects in cache and stores in a dictionary object.
IDictionaryEnumerator CacheEnum = HttpContext.Current.Cache.GetEnumerator();


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What is Expression Blend?

Microsoft Expression Blend is a user interface design tool from Microsoft for creating graphical interfaces for web and desktop applications.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What are the disadvantages of using Hidden Fields?

1. Not Secure
2. Reduces Performance on huge data
3. Doesnt support complex data


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What are the advantages of using Hidden Fields?

1. Easy to implement.
2. Data is cached at client side hence supports Web Farms
3. Most of the browsers support them
4. Reduces usage of server resources


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

What are the Session Modes which support Session_End event?

InProc mode alone has Session_End Event.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

How can we access cache object in ASP.NET ?

You can get the cache object either from Cache property of HttpContext class or Page object.


1.www.codecollege.NET 2.http://www.interviewsguru.com 3.The Encylopedia of Web Sites 4.Blogging and Earning

LinkWithin

Blog Widget by LinkWithin

Recommended Books