When a table exceeds a billion rows, creating a primary key clustered index can turn a routine operation into a disaster, but by using OFFLINE mode, MAXDOP, SORT_IN_TEMPDB, proper tempdb sizing, and a detailed runbook, you can safely rebuild the table with minimal impact.
This article compares PostgreSQL and SQL Server data access methods—including sequential scans, index scans, bitmap heap scans, index‑only scans, and parallel query execution—highlighting PostgreSQL's lack of clustered indexes and the performance implications of each approach.
Action OMS, a customized version of OceanBase’s OMS tool, enables seamless migration and real‑time data subscription from Microsoft SQL Server (2008‑2019 Enterprise) to OceanBase, detailing preparation, configuration, CDC setup, and best‑practice considerations for reliable, low‑latency data transfer.
The Aikexing open‑source community announces a giveaway of the technical book “SQL Server Operations Guide”, detailing its four‑part content on installation, performance tuning, security, multimodal data, and high‑availability architecture, authored by veteran DBA Lin Yonghua, and inviting beginners, developers, and educators to participate.
SQL Server 2025 introduces a native VECTOR data type for AI workloads, a robust Change Event Streaming system that rivals CDC, built‑in SQL Copilot for natural‑language query generation, GraphQL support via Data API Builder, runtime parameter optimization, and deeper Azure integration for cloud‑first agility.
This guide explains why Amazon S3 is an economical, scalable storage option for SQL Server backups and provides a step‑by‑step tutorial—including IAM policy creation, bucket setup, backup job scripting, synchronization, and cleanup—to achieve automated, reliable, and cost‑effective data protection.
This article details a step‑by‑step AWS cloud‑native solution that combines 10 Gbps internal networking, Elasticsearch distributed indexing, Windows Server tuning, SQL Server read‑write splitting, and intelligent load‑balancing to reduce search latency by 80 % and boost database throughput by 300 % under million‑level concurrency.
SQL Server 2025 introduces a native Vector data type for AI workloads, a robust Change Event Streaming system that extends CDC to Azure and Kafka, an SSMS‑integrated SQL Copilot for natural‑language query generation, built‑in GraphQL support, runtime parameter optimization, and deeper Azure cloud integration.
This article provides an extensive overview of widely used database management tools across various platforms—including DBeaver, Navicat, PL/SQL Developer, Toad for Oracle, SQLyog, MySQL Workbench, HeidiSQL, Percona Toolkit, pgAdmin, SQLite Expert, and SSMS—detailing their supported databases, core features, licensing, download links, and related learning resources.
This guide compiles a comprehensive set of SQL Server commands for administrators, covering version checks, server and database properties, connection statistics, backup and restore procedures, user and role management, performance diagnostics, cache cleanup, and various maintenance tasks to streamline daily operations.
This guide explains how to enable CLR integration on Alibaba Cloud RDS SQL Server, walk through a C# sentiment‑analysis demo, show step‑by‑step deployment of the CLR assembly, test the function with sample data, and discuss security options and best‑practice considerations.
A collection of Zhihu users compares SQL Server and MySQL, highlighting SQL Server's superior locking, performance on massive tables, richer backup and restore tools, tighter C# integration, and enterprise adoption, while acknowledging MySQL's free, lightweight nature and its historical limitations.
This article explains what SQL Server deadlocks are, why they occur, demonstrates a reproducible deadlock scenario with T‑SQL code, and provides practical strategies such as proper schema design, indexing, query optimization, shorter transactions, appropriate isolation levels, and monitoring to minimize deadlock occurrences.
This article walks through a common DBeaver CSV‑to‑SQL Server import error caused by mismatched numeric values, explains how to diagnose the issue by checking column types, and provides a clear, illustrated solution to ensure successful data loading.
This article explains the principle of deadlocks, the four necessary conditions, how they manifest in SQL Server resources, methods for investigating deadlocks with system procedures and Profiler, and practical techniques—including isolation level changes, lock timeouts, and bound sessions—to avoid and resolve them.
This article explains how column store indexes in SQL Server store each column separately, dramatically improve query performance through batch processing and compression, outlines their physical structure, encoding methods, creation syntax, maintenance steps, and space usage considerations.
This article explains how columnstore indexes differ from traditional row stores, detailing their batch processing, compression, and storage mechanisms that can boost data‑warehouse query performance by up to ten times while reducing storage size dramatically.
The SQLE 2.2302.0-pre3 release introduces a preview version of the SQL audit tool with enhanced SQL Server audit plugin, new rule support, context-aware auditing, rollback generation, and several UI optimizations, while providing links to repositories, documentation, and demo environments.
This guide presents thirty practical SQL Server optimization techniques—including proper indexing, avoiding full table scans, rewriting predicates, and minimizing temporary objects—to help developers write faster, more efficient queries and improve overall database performance.
This guide compiles fundamental SQL Server commands for creating, modifying, and deleting databases and tables, advanced query operators, join strategies, pagination, data synchronization, performance tuning, backup and restore procedures, and useful built‑in functions, providing a comprehensive reference for database professionals.
An extensive collection of SQL Server commands, queries, and administrative procedures covering database creation, table manipulation, indexing, backup, security, replication, and performance tuning, presented with code examples and practical tips for developers and DBAs seeking a handy reference guide.
This article provides a comprehensive collection of SQL Server commands and techniques, covering database creation, table manipulation, queries, indexing, backup, replication, and advanced operations, offering practical examples and code snippets for developers and database administrators.
This article provides an extensive collection of SQL Server commands and techniques covering basic database creation, table manipulation, advanced queries, backup and maintenance, as well as detailed steps for setting up linked servers, snapshot replication, and synchronization procedures between servers.
The July 2023 DB-Engines ranking shows Oracle, PostgreSQL and MongoDB slipping, while MySQL and Microsoft SQL Server climb, and provides detailed scores, trend charts, and the methodology behind the monthly popularity scores for the top ten database systems.
This article presents thirty practical tips for optimizing SQL queries—covering index creation, avoiding costly operators, rewriting predicates, using set‑based logic, and managing temporary objects—to dramatically reduce full table scans and improve overall database performance.
The article examines how to design cross‑database date and time storage by comparing MySQL, Oracle, and SQL Server date‑time types, discussing their formats, ranges, storage sizes, and trade‑offs, and proposes practical solutions such as using timestamps, custom conversion functions, and ORM considerations.
Ctrip’s hotel order platform evolved from a single SQL Server instance to a multi‑IDC, sharded architecture, and this article details the middleware‑driven migration, unified caching, data‑chain redesign, consistency safeguards, and operational practices that enabled seamless, high‑performance order processing at millions of transactions per day.
The March 2024 DB‑Engines ranking reveals Oracle, MySQL and SQL Server losing ground while PostgreSQL surges, Snowflake climbs, and detailed top‑10 lists across relational, key‑value, document, time‑series, and graph databases illustrate shifting popularity trends based on five industry metrics.
This guide explains how to create a read‑only login in Microsoft SQL Server, map it to specific databases, assign the db_datareader role, and optionally grant permission to view stored procedures, while also summarizing common server and database roles.
The article evaluates three data‑insertion techniques—repeated single inserts, XML‑based SQL concatenation, and batch processing—within a SpringBoot application using SQL Server, presenting code examples, test results, and recommendations on when to use each method.
Kettle, a pure‑Java open‑source ETL tool (Chinese name "Shuihu"), enables efficient, installation‑free data extraction and synchronization, allowing you to copy tables or views from a SQL Server database directly into a MySQL table using a straightforward workflow.
This article evaluates three ways to insert records into a SQL Server database—repeated single inserts, XML‑concatenated SQL, and batch processing—under SpringBoot, presents performance tests, and recommends the most suitable approach based on data volume and code simplicity.
The August 2023 DB‑Engines popularity ranking shows Microsoft SQL Server suffering the steepest score decline, while PostgreSQL and MongoDB post significant year‑over‑year gains, and the top three databases also fell, with the report detailing score trends, category rankings, and the five metrics used to calculate popularity.
This article explains SQL Server's evolution from legacy high‑availability solutions to the modern AlwaysOn architecture, detailing its data‑synchronization process, synchronous and asynchronous commit modes, failover scenarios, and practical deployment recommendations for enterprises handling both moderate and terabyte‑scale workloads.
This article explains the evolution of SQL Server high‑availability solutions, details the AlwaysOn availability‑group architecture, walks through its data‑synchronization workflow, compares synchronous and asynchronous commit modes, and offers practical guidance for deploying AlwaysOn in large‑scale enterprise environments.
This article walks through a systematic, onion‑layer approach to diagnosing and fixing SQL Server performance problems, focusing on hardware, system scale, internal database factors, software environment, business architecture, and code design, with a real‑world hospital case study and concrete remediation steps.
This article investigates how clustered and non‑clustered indexes affect query, insert, update, and delete performance in SQL Server 2008R2 and MySQL 5.5 using three test tables, presenting detailed timing results and concluding that clustered indexes are optimal for small datasets while indexes dramatically speed up queries in MySQL.
The DB‑Engines March 2021 ranking evaluates 364 databases, highlighting shifts among the top ten—including Microsoft SQL Server’s steep decline, MySQL’s growth surge, PostgreSQL’s continued rise, and Snowflake’s dramatic climb—while offering trend graphs and insights for professionals choosing the right database technology.
This article evaluates three ways to insert records into a SQL Server database—repeated single inserts, XML‑based SQL concatenation, and batch processing—under a Spring Boot environment, providing code examples, performance test results, and practical recommendations for different data volumes.
The article explains how our team, while building a SQL Server data catalog, adopted decoupling principles to avoid coupling business logic to a specific database, opting for domain‑generated 64‑bit IDs instead of database‑generated keys, and discusses the benefits of Snowflake‑style ID generators.
This article explains the principles of Logical Undo Logging, compares it with Physical Logging, and examines advanced recovery techniques such as SQL Server's Constant Time Recovery and the in‑memory database Silo's Force Recovery, highlighting their impact on concurrency, performance, and recovery latency.
This comprehensive cheat sheet gathers over eighty practical T‑SQL statements covering instance properties, configuration, system views, lock monitoring, backup progress, replication, Always On, FILESTREAM, job management, index maintenance, and security, providing DBAs with ready‑to‑run commands for everyday SQL Server administration and troubleshooting.
This comprehensive guide covers SQL Server fundamentals and advanced operations, including database creation, table manipulation, indexing, view management, backup and restore procedures, performance tuning, replication setup, linked servers, and a collection of practical code snippets for everyday database tasks.
This article explains the fundamentals of SQL Server locking, illustrates how row‑level locks can automatically escalate to table‑level locks during large batch operations, and provides practical techniques—such as batching deletes, adding appropriate indexes, and holding intent locks—to avoid lock escalation and improve concurrency.
This article explains the fundamentals of SQL Server transactions, the ACID properties, various lock types and modes, how to analyze and resolve blocking, the behavior of different isolation levels, and strategies for detecting and handling deadlocks, providing practical T‑SQL examples throughout.
This article explains how massive delete operations can cause row locks to be promoted to table locks in SQL Server, why this leads to blocking and errors, and provides practical techniques such as batching, indexing, and intent locks to prevent lock escalation and keep databases responsive.
This article provides a detailed collection of SQL Server commands and techniques covering database creation, table and index management, common DML statements, advanced set operators, various join types, grouping, pagination, maintenance tasks, replication setup, linked‑server usage, and a synchronization stored procedure.
An in‑depth comparison of PostgreSQL and Microsoft SQL Server examines their concurrency, partitioning, indexing, compression, cross‑platform support, and overall performance and scalability, concluding that PostgreSQL generally outperforms SQL Server across these parameters while offering more cost‑effective and flexible features.
This article explains Ctrip's high‑availability designs for SQL Server, MySQL, and Redis, describing multi‑replica strategies, evolution from legacy mirroring to AlwaysOn, multi‑node MHA management, and Redis sentinel‑based failover, while emphasizing fault‑tolerance across data centers.
A comprehensive collection of SQL Server commands covering server properties, configuration, system views, monitoring, backup, replication, Always On, file management, index operations, and troubleshooting techniques for database administrators.
This article demonstrates how to build a reusable Python class with pyodbc to connect to Microsoft SQL Server, import CSV files, create tables, and perform common operations such as push, union, and drop, providing complete code examples and explanations for each step.
This comprehensive guide covers SQL Server basics such as logging in, creating and dropping databases, tables, indexes and views, advanced query techniques like UNION, outer joins and pagination, plus maintenance tasks, backup and restore, linked‑server data transfer, replication setup, and useful scripts for database administration.
This comprehensive guide covers fundamental SQL Server operations such as creating databases, tables, indexes, and views, advanced techniques like set operators, subqueries, and linked servers, plus step‑by‑step instructions for replication, backup, compression, and automated synchronization using stored procedures and SQL Agent jobs.
This article details the AutoHome community's migration from a monolithic SQL Server database to the distributed TiDB platform, covering the performance bottlenecks that prompted the change, the evaluation of candidate databases, extensive OLTP/OLAP testing, the full‑ and incremental‑sync migration strategy, rollback mechanisms, and the resulting operational improvements.
This article explains why database indexes are crucial for performance, describes the fundamental principles of B‑Tree indexes, and compares how Oracle, MySQL, SQL Server, and PostgreSQL implement and use these indexes, helping developers master SQL optimization across platforms.
The June DB‑Engines ranking shows Oracle, MySQL and Microsoft SQL Server holding the top three spots with modest score gains, while PostgreSQL and MongoDB emerge as rising stars despite recent score drops, and cloud providers dominate the product landscape, reshaping the future of database services.
This article details a multi‑stage, file‑less attack that leveraged weak SQL Server credentials, Transact‑SQL stored procedures, and WMI to download and execute a downloader (cabs.exe) which fetched multiple botnet components, and explains the forensic steps and remediation measures taken to eradicate the threat.
This tutorial walks you through creating a virtual lab by setting up ESXi hosts, configuring a Windows Server domain controller, installing vCenter Server, deploying the vSphere Web Client, and adding SQL Server services, complete with detailed screenshots and troubleshooting tips.
In this interview, DBA leader Zhang Chong shares his hands‑on experience with MySQL high‑availability implementations, middleware design, multi‑database strategies, and practical tips for avoiding common pitfalls while building automated deployment platforms.
This article walks through a real‑world ERP database performance case, detailing the symptoms, metric analysis, root‑cause investigation across hardware, environment, and code, and a three‑phase optimization strategy that dramatically reduced latency and improved system stability.
This article chronicles Ctrip's database high‑availability and disaster‑recovery evolution—from simple SQL Server mirroring in the early years, through SAN‑based clustering and AlwaysOn, to the adoption of MySQL, Redis, MHA, and a one‑click DR automation tool—highlighting architectural decisions, challenges, and operational lessons learned.
This article details Alibaba Cloud's evolution of SQL Server RDS, covering product growth, the challenges of read/write separation, technical evaluations of AlwaysOn versus Transactional Replication, cloud architecture iterations, and the final productized solution for high‑availability database services.
This article describes how Ctrip's hotel R&D team tackled growing order‑volume challenges by sharding the database, building a real‑time Elasticsearch index, implementing a custom replication pipeline, and applying various write‑ and read‑optimizations to achieve low latency and stable performance.
This article surveys temporal database concepts, explains the SQL:2011 temporal extensions for valid and transaction time, and details how major products—DB2, SQL Server 2016, and MariaDB—implement these features, concluding with a comparative analysis of their capabilities.
This article examines the definitions, advantages, and trade‑offs of logical (surrogate), business (natural), and composite primary keys in relational databases, offering practical guidelines and best‑practice recommendations for selecting the most suitable key strategy.
This guide explains three practical ways to track SQL Server backup and restore operations—using SSMS UI, T‑SQL with the STATS option, and dynamic management views—plus how to retrieve backup history and avoid common pitfalls.
This article details the challenges of moving from SQL Server to MySQL, compares offline and online migration approaches, presents a complete toolbox—including ETL utilities, consistency checkers, CDC configuration, and rollback mechanisms—and shares practical lessons from a large‑scale production migration.
This article explains how to achieve near‑zero‑downtime online migration from SQL Server to MySQL by leveraging Change Data Capture (CDC) and the Alibaba Yugong tool, covering CDC principles, configuration, performance tuning, and practical migration steps.
When a SQL Server database crashes and you lack recent backups or usable transaction logs, you can still attempt recovery by attaching the data file, switching the database to emergency mode, running DBCC checks, and rebuilding objects, though some data loss may be inevitable.
This article explains SQL Server's simple and forced parameterization modes, shows when automatic parameterization occurs, illustrates the pitfalls such as parameter sniffing with concrete examples, and provides a practical fix using the OPTION(RECOMPILE) hint to avoid incorrect plan reuse.
This article details the background, design considerations, migration workflows, tooling choices, data consistency verification, rollback mechanisms, and practical experiences of moving a large‑scale production environment from Microsoft SQL Server to MySQL, covering both offline and online migration scenarios.
This article outlines the most frequent SQL performance mistakes—such as misusing UPDATE, over‑selecting columns, unnecessary double queries, and improper use of GUIDs—and provides concrete, actionable techniques like CASE expressions, temporary tables, batch operations, and table‑valued functions to dramatically improve query speed and concurrency.
This article walks through a real‑world SQL Server performance incident, explaining how to analyze hardware, system scale, internal database factors, and software environment, and presents concrete steps—including patching, configuration tweaks, and code changes—to eliminate CMEMTHREAD waits and improve overall database throughput.
This article walks through a real‑world SQL Server performance‑tuning investigation, explaining the six‑factor analysis framework, diagnosing CMEMTHREAD waits, and presenting concrete hardware, configuration, and code‑level solutions that eliminated the issue and improved overall database throughput.
This guide explains how TFS stores its data in SQL Server, outlines the four core databases and the Analysis Services multidimensional warehouse, and provides step‑by‑step instructions for creating Excel‑based reports using the Tfs_Analysis cube and code churn metrics.
This article walks through a real‑world monitoring project that must store over 400 million rows per day in SQL Server 2012, detailing the performance bottlenecks, bulk‑copy tuning, schema redesign, partitioning strategies, index removal and creation, and query‑optimisation techniques that finally achieve sub‑second query times and meet strict latency requirements.
This guide outlines best practices for SQL Server database design, covering recommended field types, primary key and null policies, index creation rules, low‑selectivity column handling, and a comprehensive set of query‑writing conventions to improve performance and maintainability.
This article explains what the NOLOCK hint does in SQL Server, why it is used, how it relates to transaction isolation levels, presents practical tests, discusses the relevance of NOLOCK after newer SQL Server versions, and shows why MySQL does not need an equivalent hint, offering guidance on when to apply it.
This guide compares SQL Server and Oracle across ten key areas—including data types, date functions, default constraints, string concatenation, identity columns, conditional statements, CASE syntax, triggers, stored procedures, and user creation—providing concrete code examples for each difference.
A slow SQL Server query that took 35 seconds to load 4,000 rows was dramatically accelerated by analyzing the execution plan, adding targeted non‑clustered indexes, eliminating costly scalar functions, and rewriting the query with CTEs and FOR XML PATH, ultimately achieving a ten‑fold speedup.
This article compares SQL Server, Oracle, and MySQL, outlining each system’s key advantages such as scalability, platform support, performance, and cost, while also detailing their main drawbacks including limited openness, hardware demands, security complexities, and feature gaps, helping readers choose the most suitable database.
The review evaluates Huawei's ES3600 v3 enterprise NVMe SSD, detailing its specifications, benchmark methodology, and performance results across SQL Server, MySQL, and synthetic workloads, and concludes with an assessment of its strengths, weaknesses, and suitability for latency‑sensitive database applications.
SQL Server 2017 introduces AI integration, cross‑platform support, Python and R machine‑learning capabilities, stronger data‑layer security, and enhanced BI tools, offering enterprises smarter data management and more flexible, powerful analytics across diverse environments.
This article explains the end‑to‑end storage I/O path, analyzes how each node contributes to overall latency, compares IOPS and throughput, and provides practical guidance on configuring storage for Microsoft SQL Server workloads.
This article walks through the fundamentals of SQL Server, covering installation, core SQL concepts, DML and DDL commands, and detailed examples of SELECT, INSERT, UPDATE, and DELETE statements with accompanying syntax illustrations to help beginners master relational database operations.
A colleague handed over a seemingly simple SQL Server query that ran in five seconds for early dates but never returned for later dates, and the article walks through the diagnosis, execution‑plan analysis, statistics update, and final fix that restored performance.
This article explains SQL Server aggregate functions, detailing scalar and hash aggregation concepts, demonstrates execution‑plan analysis with COUNT examples, and provides practical optimization techniques such as avoiding sorting and adding non‑clustered indexes, while also covering monitoring metrics for performance tuning.
This article explains SQL Server's logical and physical query execution order, offers practical techniques such as converting loops to batch operations, using temporary tables, optimizing indexes, and avoiding common pitfalls, all illustrated with code samples and performance measurements.
This article explains practical strategies for indexing dimension and fact tables in a data warehouse, covering when to use clustered versus non‑clustered indexes, how to handle surrogate and business keys, partition considerations, and tips for evolving index designs as data grows.
This article compares how to create tables and perform upsert (insert‑or‑update) operations in MS SQL and Oracle, presenting five distinct Oracle techniques—including implicit cursor, exception handling, dual table, no_data_found, and MERGE—each with complete PL/SQL code samples.
This article provides a step‑by‑step tutorial on preparing the environment, configuring the query analyzer, using SQL Server Profiler, and applying common commands such as clearing caches and enabling statistics to identify and resolve performance bottlenecks in SQL Server queries.
This article explains SQL Server's logical query execution sequence, details the physical step‑by‑step processing, and provides practical optimization advice such as avoiding SELECT *, using proper indexes, handling temporary tables, rewriting subqueries, and safely managing transactions to improve performance and maintainability.
This guide walks through building a SQL Server Failover Cluster on QCloud, covering architecture choices, network layout, required roles like DTC, step‑by‑step installation on two nodes, configuration of virtual IPs, and recommendations to prefer AlwaysOn or PaaS solutions for production reliability.
The article recounts a performance bottleneck in a Windows service that processed only about 12 records per second, analyzes why a simple SELECT TOP 1 query without proper indexes caused 89 ms latency, and demonstrates step‑by‑step how adding appropriate clustered and non‑clustered indexes reduced the execution time to virtually zero, while also discussing broader indexing strategies and common LEFT JOIN pitfalls.
This article explains why a SQL Server paging query using TOP can take minutes, demonstrates how switching to ROW_NUMBER() with CTEs, index hints, temporary tables, and hash joins dramatically reduces execution time, and provides practical tips for handling large page numbers.
This tutorial demonstrates how to containerize a legacy ASP.NET MVC 2 web application with a SQL Server database by running a Windows Container, configuring volume mappings, updating connection strings, creating a Dockerfile, building an image, and deploying the service.
This guide walks through identifying the root cause of a SQL Server instance's 100% CPU usage using Profiler, analyzing the offending queries, and applying targeted index and query optimizations to dramatically reduce CPU consumption.
This article explains SQL Server’s simple and forced parameterization modes, shows how automatic parameterization can cause plan reuse and inaccurate row‑count estimates, and demonstrates how to detect and resolve these issues using OPTION(RECOMPILE) and proper indexing.
This article walks through a real‑world SQL Server case study, explaining how to assess system hardware, interpret performance counters and wait statistics, identify CPU, memory, disk and indexing issues, and apply a three‑stage optimization process to dramatically improve database performance.
A client reported intermittent database slowness, which was traced to high CXPACKET wait times; the article explains the CXPACKET mechanism, provides a diagnostic script, analyzes disk I/O bottlenecks, and offers practical recommendations such as faster disks, separating data and log files, and isolating large log tables.
