BestHub
Sign in
Tag

T-SQL

1 views collected around this technical thread.

Python Programming Learning Circle
Python Programming Learning Circle
Nov 7, 2022 · Databases

Comprehensive SQL Techniques: Pivot/Unpivot, String Replacement, Date Conversion, Division, NULL Handling, and Performance Tips

This article presents a collection of practical T‑SQL techniques—including row‑to‑column pivots, column‑to‑row unpivots, string replacement, date/time conversion, division with percentage formatting, NULL handling, counting methods, UNION ALL inserts, cache inspection, plan cache clearing, line‑break handling, TRUNCATE vs DELETE, system diagnostics, and execution‑time measurement—each illustrated with complete SQL code examples.

DatabasePerformanceSQL
0 likes · 17 min read
Comprehensive SQL Techniques: Pivot/Unpivot, String Replacement, Date Conversion, Division, NULL Handling, and Performance Tips
Laravel Tech Community
Laravel Tech Community
Aug 17, 2022 · Databases

Comprehensive SQL Server Database Operations and Techniques 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.

DatabaseSQLSQL Server
0 likes · 23 min read
Comprehensive SQL Server Database Operations and Techniques Guide
Top Architect
Top Architect
Jul 15, 2022 · Databases

SQL Query Optimization Tips to Avoid Full Table Scans

This article presents a comprehensive list of practical SQL query optimization techniques, emphasizing how to avoid full table scans by using proper indexing, rewriting WHERE clauses, avoiding certain operators, functions, and expressions, and providing example code snippets to improve database performance.

Database PerformanceIndexesQuery Optimization
0 likes · 10 min read
SQL Query Optimization Tips to Avoid Full Table Scans
Top Architect
Top Architect
Oct 13, 2020 · Databases

Why Reusing Stored Procedures Is Tricky: Counting Results and Maintaining Code

The article examines the difficulties of reusing SQL Server stored procedures to obtain simple boolean checks, illustrates a concrete example of counting jobs with temporary tables, discusses maintenance pitfalls, and concludes that business logic is often better implemented outside stored procedures.

Database DesignPerformanceSQL
0 likes · 6 min read
Why Reusing Stored Procedures Is Tricky: Counting Results and Maintaining Code
Top Architect
Top Architect
Aug 29, 2020 · Databases

SQL Query Optimization and Stored Procedure Refactoring for Large‑Scale MES Reporting

The article describes how a massive MES reporting query that took over half an hour to run was analyzed, re‑engineered with proper indexing, partitioning considerations, and a comprehensive stored‑procedure redesign, resulting in sub‑second response times for both backend analysis and front‑end B/S applications.

Database OptimizationIndexingPerformance
0 likes · 22 min read
SQL Query Optimization and Stored Procedure Refactoring for Large‑Scale MES Reporting
Java Captain
Java Captain
Aug 15, 2020 · Databases

Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication

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.

Database AdministrationLinked ServerQuery Optimization
0 likes · 22 min read
Comprehensive SQL Server Cheat Sheet: Basics, Advanced Queries, Administration, and Replication