SQL Delete Duplicate Rows from a SQL Table in SQL Server There are scenarios when you need to DELETE Duplicate Rows in SQL Server Table or REMOVE Duplicate Rows in SQL Table. Deleting Duplicate Records from...
Category - Developers
Ashish MehtaCOVID-19 Dashboard
Coronavirus (COVID-19) Dashboard provides an overview of its impact. The dashboard also includes the total number of cases reported by each country. Data is refreshed automatically. COVID-19 Vaccination Status...
Discover SQL Server Components Installed Using SQL Server Discovery Tool
Microsoft Introduced SQL Server Discovery Tool is widely used by SQL Server Database Administrators to quickly identify SQL Server Components which are already installed on a local SQL Server. The report shown in the...
Different States of SQL Server Database
SQL Server Database can reside in one among the seven states. For example these can be ONLINE, OFFLINE, RESTORING, EMERGENCY, SUSPECT etc. This article explains each of these states and includes a T-SQL code which can...
How to Get SQL Server Instance Information
In this article we will take a look at different ways in which a DBA or a Developer can Retrieve System and SQL Server Information. The method mentioned is applicable for SQL Server 2005 and all higher versions. Below...
How to Use SQL Server Configuration Manager
How to Use SQL Server Configuration Manager to Manage SQL Server Services, Configure Network Protocols, and Network Connectivity Configuration “SQL Server Configuration Manager” is a tool that can be used to...
How to Configure a Contained Database Feature in SQL Server
Contained Databases is a new feature which was initially introduced in SQL Server 2012. A contained database is a database that will store all its metadata within the database thereby not storing any configuration...
Chetna BhallaHow to Identify SQL Server Cluster Node and Shared Drives Information Using TSQL Queries
When you have a Multiple SQL Server Cluster Configuration and multiple shared drives it becomes tough to know which SQL Server Failover Cluster Instance is using which Shared Drives. This article has the collection of...
SQL Server WHERE Clause T-SQL Tutorial with Examples
The WHERE Clause is used to fetch records from a table which meets the condition mentioned in the WHERE Clause. This is Part 5 of 40 Part SQL Server T-SQL Tutorial. Click here to read it from the beginning…. WHERE...
SQL Server ORDER BY Clause T-SQL Tutorial with Examples
The ORDER BY Clause is used to order the result set in ascending or descending order. By default, when ORDER BY clause is used the result set is ordered in the ascending order. This is Part 4 of 40 Part SQL Server T-SQL...
SQL Server SELECT TOP Clause T-SQL Tutorial with Examples
The SELECT TOP Clause is used to specify the percentage of rows or to specify the number of rows which needs to be retrieved from a given table. This is Part 2 of 40 Part SQL Server T-SQL Tutorial. Click here to read it...
SQL SELECT | SQL QUERY | SQL SELECT Statement T-SQL Tutorial with Examples
SQL SERVER SELECT Statement | SQL SELECT TABLE | SQL SELECT | SQL QUERY The “SQL SELECT statement” is used to select data from a database. In SQL SERVER, the SELECT Statement is used to query the data stored...
How to Restore Database in SQL Server?
Summary This article mentions different methods to restore the database in SQL Server from the backup files (.bak files). You can RESTORE a database from a backup file using SQL Server Management Studio (SSMS) or...
Backup Database SQL Server
SQL Backup | How to Create a Full Backup of Database in SQL Server This article explains the steps you need to follow to take a FULL Backup of Database in SQL Server Using SQL Server Management Studio and by using TSQL...
How to Drop Database in SQL Server by Closing Existing Connections
SQL Server DROP Database | SQL DROP Database Statement This article outlines the steps to DROP Database in SQL Server when the users are connected to a SQL Server Database. You may need to closing existing connections...
How to Download WideWorldImporters Sample Database and Restore in SQL Server 2016
Microsoft has introduced a new sample database WideWorldImporters specifically for SQL Server 2016. Let us take a look at how to download and restore SQL Server 2016 WideWorldImporters Sample Database. Steps...
SERVERPROPERTY Function T-SQL Enhancement in SQL Server 2016
SERVERPROPERTY is an inbuilt function which gives you information about the server instance. Learn How To Get SQL Server Info Using SERVERPROPERTY Function in SQL Server. This is Part 10 of 10 Part T-SQL Enhancements in...
FORMATMESSAGE Statement T-SQL Enhancement in SQL Server 2016
FORMATMESSAGE statement is enhanced in SQL Server 2016 to accept a msg_string argument. In the previous versions this function was used to form a message from text located in sys.messages This is Part 9 of 10 Part T-SQL...
STRING_SPLIT Function and STRING_ESCAPE Function in SQL Server 2016
SQL Server 2016 introduces two new string functions namely STRING_SPLIT and STRING_ESCAPE. This is Part 8 of 10 Part T-SQL Enhancements in SQL Server 2016 for Developers and DBAs. Click here to read it from the...
COMPRESS and DECOMPRESS T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces two new system functions namely COMPRESS and DECOMPRESS. This is Part 7 of 10 Part T-SQL Enhancements in SQL Server 2016 for Developers and DBAs. Click here to read it from the beginning…...
ALTER DATABASE SET AUTOGROW_ALL_FILES T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces two new options to ALTER DATABASE statement which can be used to modify database files namely AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES. In the earlier versions of SQL Server...
ALTER DATABASE SET AUTOGROW_SINGLE_FILE T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces two new options to ALTER DATABASE statement which can be used to modify database files namely AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES. In the earlier versions of SQL Server...
MAXDOP for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP T-SQL Enhancement in SQL Server 2016
SQL Server 2016 brings MAXDOP settings, for DBCC CHECKDB, DBCC CHECKTABLE and DBCC CHECKFILEGROUP command. Database Administrators can leverage MAXDOP settings to above mentioned DBCC commands to achieve Max Degree of...
ALTER TABLE WITH (ONLINE=ON | OFF) T-SQL Enhancement in SQL Server 2016
SQL Server 2016 introduces an interesting T-SQL enhancement to improve performance and reduce downtime ALTER TABLE WITH (ONLINE = ON | OFF). This statement will help you alter data types, change column/table collation...
DROP IF EXISTS SQL Server T-SQL Enhancement in SQL Server 2016
DROP IF Exists SQL Server | DROP IF Exists Table | DROP IF Exists Procedure SQL Server 2016 introduces a new DROP IF EXISTS SQL Server statement to DROP objects such as tables, columns, indexes, stored procedures...
TRUNCATE TABLE WITH PARTITIONS T-SQL Enhancement in SQL Server 2016
Truncate Table WITH Partitions SQL Server | Truncate Table SQL Server | It is a well known fact that TRUNCATE TABLE is faster than DELETE statement. TRUNCATE TABLE SQL Server uses lesser system resources and transaction...
T-SQL Enhancements in SQL Server 2016 for Developers and DBAs
SQL Server 2016 introduces many new T-SQL features for Developers and Database Administrators. Let us take a look at some of the new T-SQL enhancements in SQL Server 2016 along with relevant examples. This is Part 1 of...
Download SQL Server 2016 Developer Edition for Free
SQL Server 2016 Download Developer Edition for Free Microsoft announced the release of the Release to Manufacturing (RTM) version of SQL Server 2016 on June 1, 2016. The good news is that you can download SQL Server...
How to Export records from SQL Server to Text File using BCP Command
Introduction Is there a quick way to export records from SQL Server to text file? In this tip we will take a look at an example to export records from SQL Server to text file using BCP. In this tip we will learn how to...
Configure Network Drive Visible for SQL Server During Backup and Restore Using SSMS
Introduction Most of the Development and Test Database Servers will not have enough disk space to store both the database and backup files in order to perform the periodic database refreshes. In such scenarios, the best...
Download SQL Server 2014 Developer Edition Free
Introduction Download Microsoft SQL Server 2014 Developer Edition for Free for Visual Studio Dev Essentials Members Microsoft has announced that the SQL Server 2014 Developer Edition will available for free to Visual...
Convert Seconds to Minutes, Hours and Days in SQL Server
As a developer there are times when yo need to convert seconds to minutes, hours and days. The TSQL script mentioned in this article can be used to easily Convert Seconds to Minutes, Hours and Days. Learn How to FORMAT...
Display Line Numbers in SQL Server Management Studio (SSMS)
SSMS Show Line Numbers | SSMS Line Numbers This article explains how to enable SSMS show line numbers. SHOW Line Numbers in SQL Server Management Studio As a developer you may have often encounter errors while debugging...
FORMAT SQL Server Dates Using FORMAT Function in SQL Server
FORMAT Date in SQL Server FORMAT Function was introduced in SQL Server 2012, and it is available in all the later versions of SQL Server. This article will show different examples of using the new FORMAT function in SQL...
