Why SQL Queries Run Fast in Testing but Time Out in Production

·2 views

A common but frustrating database issue called parameter sniffing causes SQL Server to compile an execution plan based on the first set of parameter values it encounters, then reuse that plan for all subsequent queries. When later queries involve vastly different data volumes, the cached plan becomes inefficient — for example, an Index Seek plan built for 5 rows performs poorly when applied to 500,000 rows. Developers can diagnose the problem by querying SQL Server's plan cache using Dynamic Management Views (DMVs) to compare the parameter values used at compile time versus runtime. If those values differ significantly, parameter sniffing is likely the cause of the slowdown. Common fixes include using OPTIMIZE FOR UNKNOWN query hints, relying on local variables in stored procedures, refreshing stale index statistics, or leveraging SQL Server's Query Store to enforce a known good execution plan.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Two July 2026 Papers Show AI Advances by Compressing Physics, Not Accumulating Data

Two independent research developments in July 2026 support the idea that AI systems improve understanding by compressing information rather than simply storing more of it. The Chinese Academy of Sciences released PhiZero, a world model that encodes video changes into roughly 256 physical-language tokens instead of 44,800 visual tokens — a 175x reduction — allowing the system to reason about physics before rendering future frames. This compressed representation generalizes across materials, embodiments, and environments without requiring paired training data. Separately, Fudan University researcher Zhang Hongliang was named to MIT Technology Review's 2026 TR35 China list for using AI to model how nuclear reactor materials degrade under neutron irradiation over decades. His work, grounded in micro- and nano-scale physics, compresses what would otherwise require decades of physical testing or costly simulations into predictive AI models of structural material behavior.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Uses Shared Markdown File to Coordinate Multiple Parallel AI Coding Sessions

A solo developer running multiple simultaneous Claude Code sessions discovered that parallel AI agents had no awareness of each other's work, leading to near-deletion of active branches and merge conflicts. To fix this, he created a single shared markdown file — a 'blackboard' — that every session reads and writes to track task status and file ownership. Sessions must claim a task before starting it, and stale claims older than seven days can be reclaimed after verifying the branch's actual state via Git. The approach mirrors established computer science concepts such as the Blackboard pattern from the 1970s, stigmergy, and Kanban-style task management. The developer concludes that the real bottleneck in AI-assisted solo development is not compute parallelism but the absence of a persistent, shared context across sessions.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Nano Banana MCP Brings Image Generation Tools to Claude, VS Code, and Cursor

Nano Banana MCP is a server that integrates image generation and editing capabilities directly into AI coding assistants such as Claude Desktop, VS Code, and Cursor. It exposes four core tools — covering image generation, editing, and task status queries — so users can handle visual tasks without leaving their development environment. The server supports three models, including nano-banana-pro, and is installed via pip or cloned from its GitHub repository. Configuration requires adding an MCP server entry to the client's settings file and supplying an Ace Data Cloud API token as an environment variable. Once set up, users can describe image tasks in plain language and have the assistant route requests to the appropriate Nano Banana tool within a normal chat session.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

bubblemcp-test-kit Lets Developers Test MCP Servers With Zero Configuration

A developer has released bubblemcp-test-kit, an open-source JavaScript library designed to simplify testing of Model Context Protocol (MCP) servers and AI agents. Traditional API testing tools struggle with MCP servers because they expose dynamic interfaces to large language models over stdio, HTTP, or SSE transports. The toolkit offers transport-agnostic support, fluent assertions, mock and replay capabilities, and fault injection for agent behavior testing — all without requiring backend accounts or complex setup. It also includes a CLI command that auto-discovers tools, validates JSON Schema outputs, and scans for security issues like prompt poisoning or credential leaks. The package is publicly available on npm and GitHub under the BubbleMCP organization.

0 comments Read more at DEV Community