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.
This article presents a comprehensive design for a high‑availability private‑cloud solution for SQL Server that leverages Windows Server 2012 R2 features such as Hyper‑V, SMB 3.0, SOFS, and Storage Spaces to replace traditional SAN‑based clusters with a more flexible, cost‑effective architecture.
This article explains what execution plans are, why seemingly identical SQL statements can produce different plans, and offers practical tips—such as standardizing query syntax, simplifying nested queries, using temporary tables, bind variables, appropriate transaction scopes, and careful use of NOLOCK—to improve database performance and avoid common pitfalls.
This article compiles the 2016 release notes and major new features of leading relational database systems—including Oracle 12c R2, MySQL 5.7, Percona, MariaDB, SQL Server 2016 SP1, PostgreSQL 9.6, DB2 LUW 11.1, and Greenplum—highlighting enhancements in multitenancy, sharding, security, performance, and cloud integration.
This guide explains how to launch SQL Server 2008 Profiler, describes its key columns such as CPU, Duration, Reads, Writes, and shows how to filter traces by SPID, enabling performance comparison and session-specific monitoring.
This guide explains why SQL Server monitoring is essential, lists the critical metrics to watch, defines deadlocks, and provides multiple methods—including Performance Monitor, trace flags, Profiler, Extended Events, and the system_health session—along with step‑by‑step instructions and sample queries to detect and analyze deadlocks effectively.
This article explains the various timeout scenarios in SQL Server‑backed web applications—including ASP.NET, IIS, WebService, SSMS, remote login, and linked‑server timeouts—provides diagnostic queries such as the Connectivity Ring Buffer, and offers concrete tuning steps and best‑practice recommendations to resolve and prevent them.
The article explains the CXPACKET wait type in SQL Server, shows how to identify it with diagnostic queries, illustrates its parallelism mechanism with analogies and diagrams, and provides practical steps and hardware recommendations to resolve performance slowdowns caused by this wait.
A developer discovers a nearly full 1 TB server disk caused by large SQL Server backup files, learns the backup strategy, removes old backups while keeping monthly snapshots, manually syncs production data to a test server, and reflects on backup file formats and storage optimization.
This article presents a systematic evaluation of four SQL Server‑to‑MySQL migration tools—SQLyog, Navicat Premium, Mss2sql, and DB2DB—covering usability, speed, memory usage, data integrity, trial limitations, and additional features to help developers choose the most reliable solution for large‑scale database migrations.
This article walks through a real‑world upgrade from SQL Server 2008 R2 to 2014, detailing background analysis, data collection, solution design, detailed investigation, testing, performance baselines, side‑by‑side migration, cluster setup, application changes, and common pitfalls such as CDC issues, index‑rebuild logging, and query slowdowns.
To meet a demanding monitoring project that required storing up to 400 million records per day in SQL Server 2012, the author details a step‑by‑step journey involving bulk‑copy insertion, removing indexes during load, hourly partitioned tables, strategic index creation, and query optimizations to achieve sub‑second query times.
When a timeout error occurs because the connection pool is full, you can use sp_who or sp_who2 to list active SQL Server sessions, interpret sleeping processes, understand ADO.NET pooling behavior, and employ SQL Server Profiler to pinpoint why connections are not being reused.
This article shares a real-world case study of migrating a SQL Server 2008 R2 environment to SQL Server 2014, detailing the pre‑migration research, architecture redesign with AlwaysOn high‑availability, testing procedures, implementation steps, performance tuning, and common pitfalls encountered during the three‑month project.
This article walks through a real‑world case study of a hospital HIS running on SQL Server 2008R2, detailing the system’s hardware specs, performance metrics, three‑phase optimization process—including general tuning, statement‑level fixes, and deep CPU/memory analysis—and the measurable results achieved without adding new hardware.
A developer encountered severe slowdown when joining a remote server query via a CTE in SSIS, analyzed the underlying CTE and Nested Loops behavior, and resolved the issue by materializing the remote data into a temporary table, achieving a dramatic performance boost.
This article explains what bookmark (key) lookups are in SQL Server, shows how they appear in execution plans, and presents three practical indexing techniques—clustered indexes, covering indexes with INCLUDE, and index intersection—to remove the extra I/O overhead.
A SQL Server 2005 linked server to an Oracle database throws error 9803 for a numeric(19,4) column, with values ≥10 showing inconsistent failures, and the issue is resolved by installing the Oracle 11g client on the SQL Server host.
The article explains how SQL Server 2005 introduced schemas as separate namespaces, altering table ownership and permission rules compared to SQL Server 2000, and outlines the advantages such as role‑based access, easier user removal, default schema sharing, finer permission control, and business‑specific object organization.
This article explains the theory behind SQL Server's parallel execution, illustrates its performance gains with Amdahl's Law, lists operators that block parallelism, discusses configuration settings, warns of deadlocks and thread starvation, and presents practical MapReduce‑style optimizations for real‑world workloads.
SQL Server’s parallel query execution leverages multiple CPUs to accelerate CPU‑bound workloads, and this article explains the underlying hardware prerequisites, scheduler/task/worker model, serial vs parallel plans, exchange operators, parallel joins, CXPACKET waits, and configuration settings such as cost threshold and max degree of parallelism.
This article presents practical database optimization techniques, including SQL Server table partitioning to handle massive datasets and using the XML data type to replace traditional master‑detail designs, offering clearer schemas and faster queries for large‑scale applications.
This comprehensive guide enumerates over forty common causes of slow SQL Server queries and provides detailed optimization techniques—including indexing strategies, hardware upgrades, partitioning, cursor handling, and configuration tweaks—to dramatically improve query performance and reduce resource bottlenecks.
Learn how to verify network connectivity, open required ports, add a listener IP in SQL Server Management Studio, configure subnet settings, adjust failover cluster properties, and resolve the SQL Server error 19456 that prevents an availability group listener from binding to an IP address.
This comprehensive guide explains how SQL Server log shipping works, details the roles of primary, secondary, and monitor servers, walks through each job type, discusses execution intervals and data‑loss implications, and provides step‑by‑step failover and troubleshooting procedures.
This article provides a detailed overview of Stack Overflow's 2015 architecture, covering daily traffic growth, hardware upgrades, redundancy principles, DNS and ISP routing, HAProxy load balancing, IIS/ASP.NET web layer, Redis caching, WebSocket services, Elasticsearch search, SQL Server databases, and the open‑source tools that support the platform.
This article examines the performance bottlenecks of traditional relational databases, explains how SQL Server 2014's In‑Memory OLTP (Hekaton) uses latch‑free Bw‑tree structures, optimistic timestamp‑based concurrency, and native compilation to achieve orders‑of‑magnitude speedups, and discusses its practical limits and real‑world case studies.
This article explains why proper index design is crucial for SQL Server performance and provides detailed guidance on creating clustered and non‑clustered indexes, using ALTER INDEX to disable, rebuild, reorganize, and modify index metadata, as well as a comprehensive overview of index options and best‑practice recommendations.
This guide demonstrates how to create a linked server to Active Directory in SQL Server, query user and group information via T‑SQL, and store the results in database tables for further analysis with TFS data.
This article explains when SQL Server row overflow occurs, details the exact on‑disk pointer and data structures that store overflowed variable‑length columns across multiple pages, and highlights the performance impact and mitigation strategies for large tables.
Adding the right indexes to a complex 12‑table query dramatically cut I/O but unexpectedly increased execution time, and the article explains how an undocumented SQL Server hint forced parallelism to bring the runtime back down.
The article explains that Lync (Skype for Business) Server relies on several SQL Server instances—including CMS, RTC, and Rtcdyn—distributed across front‑end and back‑end servers, using push replication from a master to ensure data consistency and high availability, and discusses deployment considerations for standard versus enterprise editions.
This article details the experience of upgrading a sample site to ASP.NET 5 RC1 on Linux, configuring Kestrel as the web server, adding SQL Server access via Entity Framework 7, handling Alibaba Cloud RDS settings, and discussing performance issues observed with Alibaba Cloud load balancing.
During a lively Q&A session organized by the ‘Efficient Operations’ community, Oracle InnoDB principal developer Lai Zheng and Microsoft SQL Server product manager Lin Mo discuss SQL Server’s operational advantages over other databases, Microsoft’s product roadmap, common maintenance challenges, and the ideal career path for a modern DBA.
This article provides a conceptual summary of SQL Server performance tuning, explaining the goals of optimizing response time and throughput, the importance of baselines and costs, factors influencing performance, and a step‑by‑step DETECT methodology for systematic optimization.
This article explains how to convert and restore SQL Server 2000 backup files to SQL Server 2005, detailing direct restore steps, required file extensions, path adjustments, and key differences such as database creation requirements and naming conventions between the two versions.
In this interview, Microsoft experts explain how SQL Server 2014 integrates with Azure to provide hybrid‑cloud backup, disaster recovery, scalable workloads, memory‑optimized processing, robust security, and high‑performance benchmarks, illustrating its pivotal role in the company's big‑data platform.
In this technical interview, Yiche Group’s senior DBA Gao Jiwei shares how the company designs its database platform, leverages SQL Server’s in‑memory OLTP, implements high‑availability solutions, builds a private cloud with open‑source tools, and optimizes performance during massive traffic events.
This article presents a comprehensive side‑by‑side mapping of 45 common SQL Server functions to their Oracle equivalents, covering numeric, string, date, and miscellaneous operations with example queries and notes on usage differences.
In this technical Q&A, Microsoft SQL Server experts address common migration challenges, performance tuning tips, memory‑optimized table limitations, and best practices for SQL Server 2014, providing concrete guidance, reference links, and practical recommendations for database administrators.