Skip to content
Tagged articles

select statement

3 articles · Page 1 of 1
MaGe Linux Operations
MaGe Linux Operations
May 3, 2017 · Databases

Master SQL Server Basics: From SELECT to DELETE with Real Examples

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.

DELETEDatabase TutorialINSERT INTO
0 likes · 7 min read
Master SQL Server Basics: From SELECT to DELETE with Real Examples
ITPUB
ITPUB
Feb 25, 2014 · Databases

Why Database Query Optimization Matters and Key Strategies to Cut Scan Times

The article explains how costly full‑table scans in large databases, such as a bank's million‑record account table, can be reduced to minutes through effective query‑optimization techniques, and outlines the main strategies, automation possibilities, and future trends in SQL performance.

Query Tuningdatabase optimizationfull table scan
0 likes · 3 min read
Why Database Query Optimization Matters and Key Strategies to Cut Scan Times