---
title: "#t-sql articles | Hashnode"
description: "Explore 49 articles tagged #t-sql on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/t-sql"
---

Tag

# #t-sql

49 posts · 14 followers

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 2](https://hashnode.com/posts/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets/6a45ab7eaa47703809ba593c)

### [UNION vs. UNION ALL: How Hidden Sort Operators Slow Down Your Combined Datasets](https://tunedinstance.com/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets?utm_source=hashnode&utm_medium=feed)

Unmasking the duplicate check penalty: Why combining queries can trigger unexpected disk grinding, how to trace performance plan warnings, and when to drop the distinct filter safely.

7 min read · [tunedinstance.com](https://tunedinstance.com/union-vs-union-all-how-hidden-sort-operators-slow-down-your-combined-datasets?utm_source=hashnode&utm_medium=feed)

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jul 1](https://hashnode.com/posts/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops/6a4559d98141cde67a842b91)

### [Hidden CPU Burn: How Scalar User-Defined Functions Trap Your Queries in RBAR Loops](https://tunedinstance.com/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops?utm_source=hashnode&utm_medium=feed)

Unwrapping row-by-row bottlenecks: Why modular code kills database performance, how to track hidden UDF execution penalties, and how to convert functions into high-speed inline expressions.

6 min read · [tunedinstance.com](https://tunedinstance.com/hidden-cpu-burn-how-scalar-user-defined-functions-trap-your-queries-in-rbar-loops?utm_source=hashnode&utm_medium=feed)

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 30](https://hashnode.com/posts/the-local-variable-trick-how-to-stabilize-stored-procedures-and-bypass-parameter-sniffing/6a43ebc9eb3d2d20c1c66c25)

### [The Local Variable Trick: How to Stabilize Stored Procedures and Bypass Parameter Sniffing](https://tunedinstance.com/the-local-variable-trick-how-to-stabilize-stored-procedures-and-bypass-parameter-sniffing?utm_source=hashnode&utm_medium=feed)

Tuning execution plans at the code level: Why hiding parameter values from the query optimizer stops performance spikes and creates rock-solid query consistency.

7 min read · [tunedinstance.com](https://tunedinstance.com/the-local-variable-trick-how-to-stabilize-stored-procedures-and-bypass-parameter-sniffing?utm_source=hashnode&utm_medium=feed)

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 27](https://hashnode.com/posts/sql-server-deadlocks-how-to-track-down-error-1205-and-stop-query-collisions/6a4017a145aa485e4880058b)

### [SQL Server Deadlocks: How to Track Down Error 1205 and Stop Query Collisions](https://tunedinstance.com/sql-server-deadlocks-how-to-track-down-error-1205-and-stop-query-collisions?utm_source=hashnode&utm_medium=feed)

Breaking the ultimate database gridlock: Why transactions violently collide, how to extract hidden XML deadlock graphs, and how to rewrite code patterns to eliminate victim states.

7 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-deadlocks-how-to-track-down-error-1205-and-stop-query-collisions?utm_source=hashnode&utm_medium=feed)

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 26](https://hashnode.com/posts/non-sargable-queries-how-function-wrapped-columns-force-full-table-scans/6a3ebcf811e9626c5e25dbe5)

### [Non-SARGable Queries: How Function-Wrapped Columns Force Full Table Scans](https://tunedinstance.com/non-sargable-queries-how-function-wrapped-columns-force-full-table-scans?utm_source=hashnode&utm_medium=feed)

Unwrapping your indexes: Why passing database columns into functions kills search speeds, how to write SARGable code, and how to keep lookups lightning fast.

6 min read · [tunedinstance.com](https://tunedinstance.com/non-sargable-queries-how-function-wrapped-columns-force-full-table-scans?utm_source=hashnode&utm_medium=feed)

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 23](https://hashnode.com/posts/sql-server-json-performance-how-to-fix-slow-json-queries-and-index-dynamic-data-safely/6a3ad1ed70a1720a4ce35480)

### [SQL Server JSON Performance: How to Fix Slow JSON Queries and Index Dynamic Data Safely](https://tunedinstance.com/sql-server-json-performance-how-to-fix-slow-json-queries-and-index-dynamic-data-safely?utm_source=hashnode&utm_medium=feed)

Tuning the schema-less engine: Why querying JSON data fields causes massive CPU text-grinding, how to parse payloads efficiently, and how to build precise virtual indexes.

6 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-json-performance-how-to-fix-slow-json-queries-and-index-dynamic-data-safely?utm_source=hashnode&utm_medium=feed)

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 23](https://hashnode.com/posts/parameter-sniffing-why-your-stored-procedures-suddenly-run-slow-and-how-to-fix-it/6a3ad19727bda16c28b2745e)

### [Parameter Sniffing: Why Your Stored Procedures Suddenly Run Slow and How to Fix It](https://tunedinstance.com/parameter-sniffing-why-your-stored-procedures-suddenly-run-slow-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed)

Solving the plan cache guessing game: Why a fast query turns into a slow bottleneck overnight, how to spot execution plan mismatch alerts, and how to stabilize performance safely.

6 min read · [tunedinstance.com](https://tunedinstance.com/parameter-sniffing-why-your-stored-procedures-suddenly-run-slow-and-how-to-fix-it?utm_source=hashnode&utm_medium=feed)

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 22](https://hashnode.com/posts/sql-server-implicit-conversions-how-to-fix-data-type-mismatches-and-stop-slow-index-scans/6a399ec77a0cad587133817c)

### [SQL Server Implicit Conversions: How to Fix Data Type Mismatches and Stop Slow Index Scans](https://tunedinstance.com/sql-server-implicit-conversions-how-to-fix-data-type-mismatches-and-stop-slow-index-scans?utm_source=hashnode&utm_medium=feed)

Stopping the silent query killer: Why matching the wrong data types breaks your indexes, how to find hidden execution plan warnings, and how to align application code.

6 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-implicit-conversions-how-to-fix-data-type-mismatches-and-stop-slow-index-scans?utm_source=hashnode&utm_medium=feed)

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 22](https://hashnode.com/posts/sql-server-query-blocking-how-to-fix-lck-waits-and-keep-traffic-moving-smoothly/6a399e9165153145644d2004)

### [SQL Server Query Blocking: How to Fix LCK Waits and Keep Traffic Moving Smoothly](https://tunedinstance.com/sql-server-query-blocking-how-to-fix-lck-waits-and-keep-traffic-moving-smoothly?utm_source=hashnode&utm_medium=feed)

Unclogging database concurrency logjams: Why queries wait in line, how to trace the root blocker, and how to fix table locking issues without risking data corruption.

6 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-query-blocking-how-to-fix-lck-waits-and-keep-traffic-moving-smoothly?utm_source=hashnode&utm_medium=feed)

[Rakesh Kishore](https://hashnode.com/@RakeshKishore) · [Jun 21](https://hashnode.com/posts/sql-server-linked-servers-how-to-fix-slow-cross-server-queries-and-stop-performance-lag/6a38342c7213a9c51d81bffe)

### [SQL Server Linked Servers: How to Fix Slow Cross-Server Queries and Stop Performance Lag](https://tunedinstance.com/sql-server-linked-servers-how-to-fix-slow-cross-server-queries-and-stop-performance-lag?utm_source=hashnode&utm_medium=feed)

Unclogging the cross-server pipeline: Why linking databases makes queries run slow, how to stop SQL Server from pulling millions of rows over the network, and how to write fast remote queries.

6 min read · [tunedinstance.com](https://tunedinstance.com/sql-server-linked-servers-how-to-fix-slow-cross-server-queries-and-stop-performance-lag?utm_source=hashnode&utm_medium=feed)
