DevSocial Blogs · SQL Server blogs

When we have more databases on a Server to backup, it is very time-consuming to backup all databases manually. In such cases, we can use T-SQL to automate these tasks. We can use SQL Server Management Studio to back up the databases or even use Maintenance Plans, but using T-SQL is a much simpler and faster approach.

Nishan AryalJan 11, 201847,583250

In this blog i am going to explain how to remove duplicate records from a table in SQL Server.

Nikunj SatasiyaJan 3, 201816,613250

Email Address is truncated with the use Convert and Varchar.

In this blog, we are trying to find in how many ways, we can find foreign key in SQL Server.

Pramod ThakurDec 9, 20179,013250

In this tutorial, I will explain how to pass the output parameter to a stored procedure in MS SQL Server.

Nikunj SatasiyaDec 8, 201723,678250

Check the Advanced Analytics status using SERVERPROPERTY In SQL Server 2017/2016

Mohamed ElqassasNov 28, 20177,703250

Check if the failover cluster is configured or not using SERVERPROPERTY In SQL Server.

Mohamed ElqassasNov 28, 201741,653250

SQL Server: Check if the Server is in single-user mode using ServerProperty

Mohamed ElqassasNov 28, 201737,318250

SQL Server: Get the Collation Details using SERVERPROPERTY

Mohamed ElqassasNov 28, 201716,926250

SQL Server: Get the default path of data and log files via SERVERPROPERTY

Mohamed ElqassasNov 28, 201730,152250

In this blog, we will see how to Get the installed product edition using "SERVERPTOPERTY".

Mohamed ElqassasNov 28, 201710,670250

Check the "Always On" availability groups manager status using SERVERPROPERTY in SQL Server.

Mohamed ElqassasNov 27, 201713,362250

Let's learn how to check if the "Always On" Availability of Groups is enabled or disabled using SERVERPROPERTY in SQL Server.

Mohamed ElqassasNov 27, 201763,079250

Check the integrated security mode using SERVERPROPERTY in SQL Server

Mohamed ElqassasNov 27, 201724,749250

Today, we will learn how to update a Table using Join In SQL Server.

Shamim UddinNov 27, 201765,287250

This blog will help users update a record while keeping the existing record value if it exists.

Sagar ShindeNov 27, 2017167,416250

Check if the full-text and semantic indexing components are installed or not using SERVERPROPERTY In SQL Server

Mohamed ElqassasNov 26, 201710,974250

Count the number of rows in table within a milisecond with more than 28 lakh records.

Purvi PandyaNov 25, 20176,115250

Get the computer name on which the SQL server instance is running via "ServerProperty"

Mohamed ElqassasNov 24, 2017149,445250

Get the full SQL Server instance name via "ServerProperty". In this blog, we will simply show How to Get the full SQL Server Instance Name using "SERVERPTOPERTY".

Mohamed ElqassasNov 24, 20179,458250

A Transact-SQL code snippet is a template containing the basic structure of a Transact-SQL statement or block. You can use snippets as a starting point when adding statements in the Database Engine Query Editor. You can insert the pre-defined snippets supplied with SQL Server, or create your own.

Suvendu Shekhar GiriNov 17, 20177,729250

Difference between GROUP BY clause and DISTINCT in sql server. When and where to use GROUP BY and DISTINCT.

Dharmraj ThakurNov 17, 2017190,414250

This article will help the user to write a complex calculation in the backend (SQL SERVER). A computed column is computed from an expression that can use other columns in the same table.

Sagar ShindeNov 7, 20176,622250

The SQL UNION operator combines two or more SELECT statements.

Morteza MousaviOct 13, 20177,037250