BestHub
Sign in
Tagged articles

SQL commands

7 articles · Page 1 of 1
Lakehouse Research Base
Lakehouse Research Base
Jan 15, 2026 · Databases

StarRocks Temporary Partitions: Complete Guide to Viewing & Safe Deletion

This guide explains why StarRocks temporary partitions block DDL operations due to metadata consistency, locking, and atomicity constraints, and provides step-by-step commands for viewing partitions via SHOW TEMPORARY PARTITIONS and information_schema, plus safe deletion using ALTER TABLE DROP TEMPORARY PARTITION with critical precautions.

DDL operationsData ValidationDatabase Administration
0 likes · 10 min read
StarRocks Temporary Partitions: Complete Guide to Viewing & Safe Deletion
MaGe Linux Operations
MaGe Linux Operations
Jun 14, 2025 · Databases

Essential DM Database Management SQL Commands You Need to Know

This guide presents a comprehensive collection of frequently used SQL commands for managing the DM (DaMeng) database, covering version and license queries, server configuration, session monitoring, object management, tablespace handling, backup procedures, and performance tuning, all illustrated with clear examples and code snippets.

DM DatabaseDatabase AdministrationSQL commands
0 likes · 6 min read
Essential DM Database Management SQL Commands You Need to Know
dbaplus Community
dbaplus Community
Aug 24, 2022 · Databases

Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques

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.

ReplicationSQL ServerSQL commands
0 likes · 27 min read
Mastering SQL Server: Essential Commands, Advanced Queries, and Maintenance Techniques
Programmer DD
Programmer DD
Sep 12, 2020 · Databases

Mastering SQL Server: Essential Commands, Tips, and Advanced Techniques

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.

Database ManagementReplicationSQL Server
0 likes · 25 min read
Mastering SQL Server: Essential Commands, Tips, and Advanced Techniques