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 an SQL Server table can sometimes become tedious, especially when you don’t have a Primary Key defined for the source table. This article […] The post SQL Delete Duplicate Rows from a SQL Table in SQL Server appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com ..read more

The SELECT DISTINCT Statement is used to fetch distinct values in a specific column of a given table. This article gives you an overview of the SQL Server SELECT DISTINCT clause or SELECT DISTINCT SQL Clause. This is Part 3 of 40 Part SQL Server T-SQL Tutorial. Click here to read it from the beginning…. […] The post SQL Server SELECT DISTINCT Clause T-SQL Tutorial with Examples appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com ..read more

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 manage all the SQL Server Services; it can also be used to configure network protocols that can be used by an SQL Server Instance. […] The post How to SQL Server Configuration Manager appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com ..read more

SQL SELECT | SQL QUERY | SQL SERVER SELECT Statement | SQL SELECT TABLE 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 in a given table of a database. The data which is returned by executing the SELECT […] The post SQL SELECT | SQL QUERY | SQL SELECT Statement T-SQL Tutorial with Examples appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com ..read more

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 Clause Syntax WHERE Clause is also used in UPDATE and DELETE Statement. How to Use […] The post SQL Server WHERE Clause T-SQL Tutorial with Examples appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com ..read more

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 Tutorial. Click here to read it from the beginning…. ORDER BY Clause […] The post SQL Server ORDER BY Clause T-SQL Tutorial with Examples appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com ..read more

The SELECT DISTINCT Statement is used to fetch distinct values in a specific column of a given table. This is Part 3 of 40 Part SQL Server T-SQL Tutorial. Click here to read it from the beginning…. SELECT DISTINCT Syntax – SQL Server SELECT DISTINCT Statement SQL Server SELECT DISTINCT Statement: How to Query Distinct […] The post SQL Server SELECT DISTINCT Clause T-SQL Tutorial with Examples appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com ..read more

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 from the beginning…. SELECT TOP Syntax – SQL Server SELECT TOP […] The post SQL Server SELECT TOP Clause T-SQL Tutorial with Examples appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com ..read more

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 in a given table of a database. The data which is returned by executing the SELECT statement is referred as result-set. Within a database data is stored within tables. In […] The post SQL SELECT Statement | SQL Server SELECT Statement T-SQL Tutorial with Examples appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DBA, SQL Server Basics, Training, etc - MyTechMantra.com ..read more

Why to configure Database Instant File Initialization in SQL Server? Its Advantages SQL Server Database Administrators can leverage Database Instance File Initialization Feature which is available in Microsoft Windows XP Professional, Windows Server 2003 or later versions to reduce the time taken to restore very large databases. The Database Instance File Initialization feature internally skips […] The post Why to Configure Database Instant File Initialization in SQL Server? Advantage appeared first on SQL Server Articles, SQL Server Tips, SQL Server Tutorials, SQL Server Tuning, SQL Server DB ..read more