[Database Edition 08] Understand SQL Execution Plans! Essential Knowledge for Finding the Cause of Slow SQL

The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...
Redmond

Restoring a Database to an Older Version of SQL Server

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...

[Introduction to DB Design & Tuning] Thinking Methods and Approaches for Blazing-Fast Optimization of 'Heavy Databases' Learned in the Field

When operating web applications or business systems for many years, the 'database (DB) performance degradation problem' is ...
techtarget

How to resolve and avoid deadlocks in SQL Server databases

The first step in learning how to avoid deadlocks in SQL Server databases is preparedness. Knowing about deadlocks -- in particular, what causes them -- is the key to preventing them and resolving ...