Exception handling in SQL Server

In SQL Server TRY..CATCH statement which helps us to handle the errors effectively in the back end....

Sachindra Singh
Database
 5170 View(s)

Copying, Merging and/or Uniting Records In SQL Server

Some time we have a situation to copy a set of rows of a Table 'A' into the Table ‘B’, it means suppose if we have thousand of records in a table ‘A’ ...

Sachindra Singh
Database
 7100 View(s)

Aggregate function in SQL Server

SQL aggregate functions are used to sum, count, get the average, get the minimum and get the maximum values from a column or from a sub-set of column ...

Sachindra Singh
Database
 8221 View(s)

Conjunctions and Dis-junctions in SQL Server

Basically the logical conjunction is used to check that two conditions are true, in logical conjunction both conditions must be verified....

Sachindra Singh
Database
 35529 View(s)

How to create table in SQL Server

As a user, you need to create tables to store data in database. While creating the tables in database, you have to follow specify certain rules and co...

Sachindra Singh
Database
 4215 View(s)

System Process in C#

The Process component is useful to obtain the list of the processes that are running on the system....

Sachindra Singh
C#
 4814 View(s)

Cell formatting of DataGridView in .NET

The DataGridView control for displaying data from your SQL database....

Sachindra Singh
C#
 15663 View(s)

What is Strong Name in Assembly?

A Strong Name consists of the assembly's identity—its simple text name, version number, and culture information (if provided)—plus a public key and a ...

Sachindra Singh
C#
 9913 View(s)

Checkpoint in Database

Checkpoint in database...

Sachindra Singh
Database
 3501 View(s)

Global Assembly Cache

What is GAC?...

Sachindra Singh
.NET
 3386 View(s)

Job in Database

What is Job in SQL Server?...

Sachindra Singh
Database
 3269 View(s)

DLL Hell in .Net

What is DLL Hell?...

Sachindra Singh
.NET
 4124 View(s)

Assembly in .Net

What is Assembly and kinds of Assembly?...

Sachindra Singh
.NET
 3118 View(s)

What is Normalization?

Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant dat...

Sachindra Singh
Database
 14310 View(s)

Denormalization in SQL Server

The intentional introduce of redundancy in a table in order to improve performance is called “Denormalization”....

Sachindra Singh
Database
 23755 View(s)