Thursday 31 March 2011

[ DOT NET ] Create ASP.NET Repeater Control Templates Dynamically

ASP.Net Repeater Databound Control can be generated dynamicallyusing C# code. You can render the data items in dynamically generated Repeater...
 View more
Posted By: Mr. Palash Paul

Understanding Transaction Isolation Levels with SSIS

The transaction isolation level determines the duration that locks are held.  We'll use SQL Server as an example...
View more
Posted By: Mr. Joydeep Das

Tuesday 29 March 2011

An Overview of XML Support in SQL Server

SQL Server 2005 adds a raft of new features to support XML data storage and manipulation. These features make it easier to persist your XML documents within the database, while providing increased performance over the traditional techniques...
View more

Posted By: Mr. Joydeep Das

[ DOT NET ]Create advanced Excel spreadsheets on the server using asp.net

Use ASP.NET and a generic XSL file to convert any XML data into an Excel spreadsheet. This generic XSL can be used to present XML reports to users in Excel via their web browser. The XML data actually gets converted to an Excel XML spreadsheet...
View more


Posted By: Mr. Palash Paul

Recursive SQL Join

Is it possible to make recursive join in SQL Server...
View more

Posted By: Mr. Joydeep Das

Thursday 24 March 2011

Why my SQL Statement taking long time to execute?

There’s a lot of instrumentation in SQL Server that helps you see what your query is doing behind the scenes to retrieve a given result set. You can use trace files, queries against Dynamic Management Views (DMVs) and Dynamic Management Functions (DMFs), and the many graphic features of SQL Server Management...
View more

Posted By: Mr. Joydeep Das

[ DOT NET ] C# LINQ


LINQ is the ability to write in line SQL style queries, known as query expressions (using query syntax).  This tutorial introduces the basic concepts...

Posted By: Mr. Palash Paul

Wednesday 23 March 2011

PIVOT and UNPIVOT

You can use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table. PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted in the final output. UNPIVOT performs the opposite operation to PIVOT...
View more

Posted By: Mr. Palash Paul

[ DOT NET ] JAVASCRIPT OBJECT NOTATION or JSON


Introduction

JavaScript Object Notation, or JSON, is a lightweight syntax for representing data. JSON is a subset of the JavaScript language and consists of JavaScript key-value pairs. It is text-based and uses Unicode. JSON nests data elements in a way similar to XML. Each instance of a JSON document describes one object with nested objects, arrays, strings, numbers, Boolean values, or null values. JSON is ideal for data interchange with Web services i.e. WebMethod...
View more
Posted By: Mr. Palash Paul

NO MORE TEMPORARY TABLES AND DERIVED TABLES

Avoid using temporary tables and derived tables as it uses more disks I/O. Instead use CTE (Common Table Expression); its scope is limited to the next statement in SQL query...

View more

Posted By: Mr. Joydeep Das