A SQL cursor is a database object that retrieves data from result sets one row at a time.The cursor in SQL can be used when the data needs to be updated row by row.

In this article you will learn about Cursors in SQL Server.

This post will cover the differences between Max Degree of Parallelism and Cost Threshold for Parallelism. These are two server settings that have a less the ideal default value. All DBAs should ...

SQL partition by. Learn how to use Row_Number function without Partition By in SQL or with Partition By in SQL. SQL Partition By Example.

A SQL trigger is a database object just like a stored procedure or we can say it is a special kind of Stored Procedure that automatically fires when an event occurs in a database. Learn what is a t...

This article explains the row_number function in SQL Server. Ranking functions provide a very good feature of assigning numbering to the records in the result set in SQL. Row_Number is one of these...

In this article, you will learn about how to create a stored procedure in SQL Server using SSMS.

In this blog, you will learn the difference between TRUNCATE, DELETE and DROP SQL commands.

In this article, you will learn about triggers.

Learn learn how to use pivot and unpivot in SQL with code example.

This post will go over how you can use the DEADLOCK_PRIORITY to prioritize your processes so that the most important ones aren't chosen as victims of a deadlock.

This article explains what cursors are in SQL Server and how to use Cursors in SQL with examples. A SQL cursor is a temporary work area created in system memory when a SQL statement is executed.

Learn the difference between SQL Union and Union All. Code example Union vs Union All in SQL.

In this article, you will learn about a detailed description of the primary key in SQL server.

In this blog, I will explain to you how to apply a script or a query to multiple databases in a single execution using a database name.

SQL Server Management Studio (SSMS) is a Windows client app that allows database developers and database administrators to configure and manage SQL Server and Azure SQL databases. Learn how to dow...

In this article, you will learn about how to display information about events.

This post will go very a few of the methods that can be used to capture failed logins to your SQL Servers.

I shared my personal experience on how can we fix corrupted databases using a third party product called stellar.

In this article, you will learn about being a woman in the sql community.

This post will focus on how to find what logins are mapped to database user accounts in a SQL Server database.

In this article, you will learn how to create a PostgreSQL Server on the Google Cloud Platform SQL Database service.

In this article, you will learn about String Function in SQL Server.

In this article, you will learn about Error 927: database can't be opened , it is middle of the restoration. it comes when we click on start mirroring. Actually this is not an error, this msg...

In this article you will learn about SQL Server in memory table indexes.