Aggregate functions are the built-in functions in SQL. They are used for specific operations like to compute the Average of the numbers, Total Count of the records, Total sum of the numbers etc. Th...

This article explains synonyms in SQL Server. SQL Server Synonyms are created in the database that need to access the other database and use them in the SELECT statement, like we access the table i...

In this article, I described how to calculate the maximum range of various integer data types in SQL Server. TINYINT, SMALLINT, INT and BIGINT are all number data types. The difference between thes...

To learn the database, most of the times, we need to build the schema and put some data inside. But to speed up the learning and make the hands dirty in code as soon as possible, large organization...

In my recent article Using Materialized Views Effectively, I offered a few ways to populate data stores that can be critical performance-improvers for your apps and BI environments that use SQL Ser...

When I started learning SQL, I found out several issues, which I thought to be interesting to share. For our needs, let us use AdventureWorks2012 database, which can be obtained here.

Here, I will tell you the possible ways to return calculated Boolean values from SQL Server code. At a lot of places, you want to progress conditionally. You send some input values to the stored pr...

Did you know that compression can gain you more than just space on a disk; it can allow you to fit more data into the buffer pool? That means queries have faster and more efficient reads which can ...

This article is about merging different row cells into one for the purpose of reporting. Sometimes we need to customize according to the client’s requirements.

I hope you all are doing fine. This particular article is about updating the dynamic columns on the go.

In this article, we will learn about identity function and how we Reset Identity Column in SQL Server. Identity keyword is used in SQL Server to Auto Increment Column value.

In my series of articles there are a few scenarios where we need to take care of some real-world samples and examples to help explain concepts to the end users. This is part 49 of the series of art...

In this article, we will learn how to create and use user-defined functions in SQL server. The function we write for reusability purpose to avoid complexity and duplication of code. User-defined fu...

Backup and Restore are common functions of a database administrator. In this tutorial, you learn how to create a SQL Server database backup and restore it back using SQL Server tools.

In this article, I am going to explain about best practices and programming guidelines in SQL Server, for all SQL programmers.

I am writing this article to share knowledge about Windows Functions or Windows Ranking Function(It is a sub part of the Windows Functions). There are many windows functions introduced in SQL Serve...

In this article we learned about exception handling in SQL Server, This article is the last article of T/SQL Series. Now, We will start learning MongoDB. I have to prepare some article on MongoDB ...

Installing SQL Server vNext On Linux. install SQL Server vNext on Ubuntu, install SQL Server on Linux. install SQL Server vNext on Linux. install SQL Server vNext.

Identifying relationship between columns in SQL. The query is given below to find the relation between any two columns in the given database. How to search the column in the database by its name.

In this article, we will learn about Database Triggers in SQL Server. We also learned the concept of Magic Tables in SQL Server.