SQL Server vs MySQL vs PostgreSQL Delete Performance, Setup SQL Server Clustering and more (MSSQLTips 10/21/2020)

[tag] [View MSSQLTips newsletter online]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [Free Webinar - Understanding Database Locking and Blocking]( [Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 3]( In this part of the series we look at the steps to install SQL Server 2019 on a pre-configured Windows Server 2019 Failover Cluster.... [SQL Server vs MySQL vs PostgreSQL Delete Performance Comparison]( In this article we do a comparison of SQL Server, MySQL and PostgreSQL to see how long large delete operations take and the impact on the database logs.... [Instantly Recover SQL Server Databases]( [Webcast] Learn how to access database data quickly and reliably using database backup files without the need to restore and take up additional space using the advanced recovery capabilities of SQL Safe Backup.... [SQL Server Analysis Services Tutorial]( SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack to develop Online Analytical Processing (OLAP) solutions. Over the years SSAS has evolved and has emerged as a leader in the area of analytical solut... [Faster SQL Server Clustering]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... [SQL Server Master Database Tutorial]( In this tutorial we cover many common questions about the master database. We look at what it is used for, location of database files, things you can and cannot do with the master database, maintenance and more.... [Improve the Data Quality for Healthcare, Clinical and Life Sciences Projects]( All companies fundamentally have the need to improve data quality for decision making. For healthcare, clinical and life sciences organizations, merging, reconciling and enhancing data is challenging for electronic medical records, clinical trials an... [How to read the SQL Server Database Transaction Log]( In this tip we will take a look at a SQL Server function that you can use to read the SQL Server transaction log to see what entries are made for database transactions.... [Delete duplicate rows with no primary key on a SQL Server table]( Every once in awhile a table gets created without a primary key and duplicate records get entered. The problem gets even worse when you have two identical rows in the table and there is no way to distinguish between the two rows. So how do you delete th... [Getting Started with the DAX queries for SQL Server Analysis Services]( I would like to learn the DAX query language for SQL Server Analysis Services Tabular Data, is there a simple tutorial to get started?... [Twitter]( [Facebook]( [LinkedIn]( [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}