Skip To Main Content
Select Orders. OrderId on Muck Rack

Select Orders. OrderId

As seen in: DEV Community, Towards Data Science, KDnuggets, CSDN, SQL Server Central, Blogarama, Analytics Vidhya, Zephyrnet
Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work. Claim your profile

Get in touch with Select Orders.

Contact Select Orders., search articles and posts on X, monitor coverage, and track replies from one place.

Learn more about Muck Rack

Actions

Share this page

Is this you?

As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile

Articles

The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek

|
By Select Orders. OrderId
| SQL Server Central
Every SQL Server developer learns the rule: don't wrap a column in a function inside your WHERE clause, or the optimizer abandons the fast Index Seek for a full Index Scan that reads every row. And everyone learns the famous exception: a date conversion like CAST(OrderDate AS DATE) = '2026-06-18' still seeks. But "date conversion" hides two genuinely different situations, and they behave differently under the hood.
Open in Who Shared Issue with article?

Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't

|
By Select Orders. OrderId, Select customerid
| SQL Server Central
In June, I wrote about a parameter-sniffing incident that turned a query that normally finished in 200 milliseconds into a 90-second outage. We stabilized the system by forcing the known-good plan in Query Store, then split small and large customers into separate code paths as the permanent fix. That left me with a question: if the database had been running SQL Server 2022 or later, would Parameter Sensitive Plan optimization have prevented the incident?
Open in Who Shared Issue with article?

Introduction to ClickHouse: The High-Speed, Scalable Columnar Database Built for Analytics

|
By Select Orders. OrderId
| Blogarama
In this post, I will introduce Clickhouse, provide a brief history, and highlight its key features. ClickHouse is a high-performance, Column-oriented SQL Database management system (DBMS) designed for online analytical processing (OLAP). It is particularly well-suited for running complex analytical queries that scan billions or even trillions of rows efficiently.
Open in Who Shared Issue with article?
See all 28 articles