Help to understand .Net

Data Compression SQL Server 2008's data compression enables you to compress data stored in the database. This reduces storage requirements and can actually improve the performance of workloads that have high I/O requirements. SQL Server 2008 also supports compressing backups. Activity Monitors This feature is totally revamped in SSMS 2008. When opening “Activity Monitor” it shows a screen similar to the following image. IntelliSense for Query Editing IntelliSense offers a few additional features besides just completing the world. You can see those options from SSMS List Members Parameter Info Quick Info Complete Word Refresh Local Cache Table-Value Parameter In many situations, it is necessary to pass a set of table structured values to a stored procedure or function. These values may be used for updating/population a table. CREATE TYPE Customer AS TABLE (             CustomerId INT IDENTITY ( 1 , 1 ),             CustomerName VARCHAR (

Encapsulation Encapsulation is a procedure of covering up of the data & functions into a single unit called as class Encapsulation is one of the fundamental principles of object-oriented programming. An encapsulated object is often called an abstract data type. Encapsulation can protect your data from accidental corruption . Rather than defining the data in the form of public , we can declare those fields as private . Encapsulation is a process of hiding all the internal details of an object from the outside world Encapsulation is the ability to hide its data and methods from outside the world and only expose data and methods that are required Encapsulation is a protective barrier that prevents the code and data being randonly accessed by other code or by outside the class Encapsulation gives us maintainability , flexibility and extensibility to our code. Encapsulation makes implementation inaccessible to