Internal of Deferred or Lazy Execution in LINQ

I have already posted about Deferred Execution here In this post we will see how internally Deferred or lazy execution is implemented. Deferred Execution executes the query only when Loop starts. What I mean here is that, we iterate through the query variable to get the result. Here the result variable does not contain the…… Continue reading Internal of Deferred or Lazy Execution in LINQ

Fetching lists from SharePoint 2010 site using client object model

Creating the UI 1. Add a label 2. Add a textbox. Give any meaningful name I am leaving default name here. 3. A button. On click event of the button list names will be fetched. 4. A listbox control to bind the lists from SharePoint site. Setting up the environment Right click on the project…… Continue reading Fetching lists from SharePoint 2010 site using client object model

Migrating Data Base from SQL Server 2008 R2 Enterprise to SQL Azure

In this walkthrough we will migrate an existing Database from SQL Server 2008 R2 to SQL Azure. Creating Database The first step is to create database. We are going to use School database. Script of sample School Database copy from here Generate Database Script for SQL Azure Right click on School Database and select Tasks.…… Continue reading Migrating Data Base from SQL Server 2008 R2 Enterprise to SQL Azure

Data Compression in SQL Server 2008

SQL Server 2008 automatically compress data stored in database. SQL server does Lossless data compression. SQL server uses Dictionary based compression algorithm. Row Level Data Compression For Row level Data Compression SQL Server does not use explicitly any standard compression algorithm. It works on very simple algorithm. Say, 1. You created a column of CHAR(50)…… Continue reading Data Compression in SQL Server 2008