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 …
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 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?? 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 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 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 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 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 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 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 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 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 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 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 …
