In this post, we will discuss how to work with SQL constraints and explain the concepts with an example in simple way. I hope this is very useful for beginners to help them understand the basic con...

We add Clauses in Query to provide the additional facilities like filtering the records, storing the records, fetching the records and grouping the records in the Table.

One of the most important routes to high performance in SQL server database is an index.

There are many problems which we face while using SQL Server. Its very important to design your database correctly and keep it working.

Do you know what is the easy way to create packages in Oracle? There are two steps in creating the package. I am using toad as an Oracle Developer Software for accessing the database.

All fields must be at the same position and the same data type, you can make all kind of selects, joins, where etc the UNION ALL comand is best then UNION if you want select all rows if they are th...

Friends, most of the time we used ranking function like ROW_NUMBER() when it required to generate unique number sequence. But there also other ways to accomplish the same thing without using rankin...

In this post, we will learn about how to replace newline characters from SQL fields. In this post, we have to use replace function for replace string and also use char function to remove newline ch...

In this article, we will discuss how to make faster SQL Server Search - Part Two.

Synonyms is database object which can be created as an alias name/duplicate name for any object like table views ,procedure etc.

JSON stands for JavaScript Object Notation. JSON is a lightweight format which is used for storing and interchange the data. JSON uses standard javascript function to convert JSON data into native ...

Do a small change on database and on your query to make it faster.

In Single Procedure, we will write multiple SQL operations. Based on the request the corresponding SQL operations will execute.

Do you know the type of views ,how to create them and their uses. In this blog I will tell you about views , how you can use them practically. Before that I want to tell you that this is my third b...

Ranking functions returns a ranking value for each row either in a partition, or not. We can produce the very same result for all functions, but they have different purpose.

In this post, we will learn about how to get all tables records count from the selected database. Here we are using sys.objects and sys.partitions for getting the record count. Here we are using jo...

This article explains how to implement simultaneous data queue processing using SQL Server. In many of our enterprise applications, we have the design to handle incoming request coming from multip...

Stuff is a function in SQL Server used to perform special operations on a string value.

In this blog, I will demonstrate how to find the highest number of employees in a particular department using SQL server 2014.

This blog shows some primary issue which puts a serious limitation on SQL Server MONEY data type.