# November 2012

## Extended Properties

Extended Properties The documentations are an important part for every developer. In this article I am trying to discuss the self-documenting process of database by using extended properties. Before writing this article, I read several article for various sources related to extended properties to collect facts. Introduction Extended properties are …

## LiangBarsky Line Clipping Algorithm with CC

Liang-Barsky Line Clipping Algorithm with C/C++ TheoryIn Liang-Barsky algorithm, we first write the point-clipping conditions in parametric form as  Each of these for inequalities can be expressed as , k = 1, 2, 3, …..where parameter p and q are defined as Any line that is parallel to one of …

## PRIMARY KEY and INDEX

PRIMARY KEY and INDEX This article is related to PRIMARY KEY and INDEX. A common misconnects is that the PRIMARY KEY is always CUSTERED index.   Before going to the depth of this article I want to ask some common questions. My questions are mentioned bellow. 1.    Is PRIMARY KEY …

## How to make Vertex Table Edge Table and Surface Table to store geometric information of an object

How to make Vertex Table, Edge Table and Surface Table to store geometric information of an object?? Listing the geometric data in three tables provides a convenient reference to the individual components of each object. Also, the object can be displayed efficiently be using data from the edge table to …

## Key Lookup

Key Lookup This article is related to Key Lookup operators and how we eliminate them to improve the performance of our query. Introduction Key lookup operator is a bookmark lookup on a table where clustered index exists. It is quite expensive in terms of performance, so we have to eliminate …

## 3D Transformation Translation Rotation and Scaling in CC

3D Transformation [Translation, Rotation and Scaling] in C/C++ Translation In a three-dimensional homogeneous coordinates representation, a point is translated from position P = (x, y, z) to position P’ = (x’, y’, z’) with the following equations. x’ = x + tx y’ = y + ty z’ = z …

## The general guidelines for Index

The general guidelines for Index We all know that the INDEX is a key factor of performance tuning. As proper index can increase the performance and bad implementation of index implementation can dramatically decreases the performance.  In this article I am trying to gather some facts from different sources, which …

## Computer Graphics Fractals generation using Mandelbrot Set with CC in CodeBlocks

Computer Graphics: Fractals generation using Mandelbrot Set with C/C++ in Code::Blocks “Clouds are not spheres, mountains are not cones, coastlines are not circles, and bark is not smooth, nor does lightning travel in a straight line.” – Benoit Mandelbrot The Mandelbrot set is created by a general technique where a …

## Blocking in SQL Server

Blocking in SQL Server In this article I am trying to explain the Blocking. What is it Blocking in SQL Server is a scenario where one connection to SQL Server locks one or more records, and a second connection to SQL Server requires a conflicting lock type on the record …

## Bezier Curves and Bezier Surfaces generation with CC in CodeBlocks

Bezier Curves and Bezier Surfaces generation with C/C++ in Code::Blocks Brief Theory of Bezier Curve In order to draw curvy surface we implement Bezier curve algorithm. In drawing Bezier we first define n+1 control point pk = (xk, yk, zk) with k varying from 0 to n. And the coordinate …

## Error handling

Error handling Error handling is a very important part of T-SQL development life cycle. Before SQL Server 2005 the error handling is quite difficult to maintain.From SQL Server 2005 Microsoft provide some easier process to handle our T-SQL error properly. In this article we are discussing about the Error handling …

## Controlling Camera and Line of Sight in OpenGL

Controlling Camera and Line of Sight in OpenGL Camera controlling is essential in 3D viewing. OpenGL provides a function gluLookAt() for this purpose. The syntax of the function gluLookAt() is void gluLookAt ( GLdouble eyex,GLdouble eyey,GLdouble eyez,GLdouble centerx,GLdouble centery,GLdouble centerz,GLdouble upx,GLdouble upy,GLdouble upz ); .csharpcode, .csharpcode pre{ font-size: small; color: …

## String To Integer and Integer to String Conversion in C

String To Integer and Integer to String Conversion in C In modern languages like Java, C# etc., there is a provision of function to handle String to Integer and Integer to String conversion. But in case of C, you should explicitly convert. String to Integer Conversion String is a array …

## Data Types

Data Types As we all know the selection of proper data types is very important for a SQL Server Table objects. Without proper data types the performance is going down and it is un manageable for SQL developer. In this article I am trying to gather and provide a chart …