Monthly Archives: January 2012

State Management Questions

  By Gaurav Agrawal | January 31, 2012 - 6:21 PM |
Leave a comment

What is View State? View State allows the state of objects (serializable) to be stored in a hidden field on the page. View State is transported to the client and back to the server, and is not stored on the server or any other external source. View State is used the retain the state of server-side objects between postabacks. What is the lifespan for items stored in View State? Item stored in View State exist for the life of the current page. This includes post backs (to the same page). What does the “EnableViewState” property do? Why would I want … Click here to continue reading. →

What are different Types of Join?

  By Gaurav Agrawal | January 30, 2012 - 6:44 PM |
Leave a comment

Cross Join: A cross join that does not have a WHERE clause produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set is the number of rows in the first table multiplied by the number of rows in the second table. The common example is when company wants to combine each product with a pricing table to analyze each product at each price. Inner Join: A join that displays only the rows that have a match in both joined tables is known as inner Join.  This is the default type of … Click here to continue reading. →

What is the difference between a Local and a Global temporary table?

  By Gaurav Agrawal | January 29, 2012 - 3:58 PM |
Leave a comment

A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement. A global temporary table remains in the database permanently, but the rows exist only within a given connection. When connection is closed, the data in the global temporary table disappears. However, the table definition remains with the database for access when database is opened next time.

What is CLR? Difference between CLS and CTS?

  By Gaurav Agrawal | January 27, 2012 - 12:54 PM |
2 Comments

CLR (Common Language Runtime) CLS (Common Language Specification) CTS (Common Type Systems) A CLR is a construct provide by the .NET framework that provides several functionalities to all .NET applications like memory management, security, Garbage collection, language independency, cross language exception handling, cross language inheritance, etc. CTS consist of all the types supported by .NET like bool, struct, enum etc; and thus keep the .net applications type safe. CLR manages the execution of code and provides different services for Base Class Libraries etc. CLR is a rich set of features for cross-language development and deployment. CLR supports both Object Oriented … Click here to continue reading. →