In this article, you will learn about temporary tables in SQL Server.

The article shows how to install SQL Server and SQL Operation Studio on Windows and Ubuntu Linux.

In this article, let us see how we can identify slow running queries and how to improve SQL Server performance by using the Database Engine Tuning Advisor.

In this article, you will learn about Azure SQL DB Failover Group Orphaned Users.

In this article, you will learn about columnstore indexes in SQL server.

Here, I will explain the difference between the On and Where clauses when used with a left join in SQL Server.

QUOTENAME Function is used to add square brackets to the starting and ending of a string and how to store strings in various formats in SQL Server.

In this article, I highlight a small feature of Temporary Stored Procedures in SQL Server. Temporary Stored Procedures are similar to normal Stored Procedures, and are two kinds of temporary Stored...

Here you will see SQL Server Database Mirroring. Database Mirroring is used to move the database transactions from one SQL Server database (Principal database) to another SQL Server database (Mirro...

You can read SQL Server Database Mirroring. Database Mirroring is used to move the database transactions from one SQL Server database (Principal database) to another SQL Server database (Mirror dat...

In SQL Server Log Shipping and Mirroring can work together to provide solutions for high availability and disaster recovery. Database Mirroring is used to move the database transactions from one SQ...

This article is a primer on databases and Sql Server. Similar to a FAQ, it is written with questions that could potentially be asked in a job interview.

In this article, we will show how to display decimal numbers as money with and without cents

This article will give you an idea of how to use the SQL Server Check Clause and also defines where you can use it.

Deadlocks occur when two users have locks on separate objects and each user wants a lock on the other's object.

This article list out the important system tables, stored procedure and views.

In this article, we are going to see how to use Bulk Insert task in SSIS.

In this article, I describe Static Cursor, Dynamic Cursor, and Keyset-Driven Cursor.

In this article, I describe how to drop all the Stored Procedures in a particular database.

In this article, I will describe how to perform left and right outer join between more than one tables in SQL Server 2008.