Reference data belongs in governed lookup tables with stable codes, clear owners, and a release process that keeps environments aligned.
SQL SERVER – The Difference between Dual Core vs. Core 2 Duo
Dual Core was a brand, not a core count. What actually matters for SQL Server is cores, clock speed and licensing. How to see what you really have.
Storing Percentages: 0.15 or 15, and How to Tell Them Apart
Storing percentages starts with a declared unit. Fractional rates and percentage points require different conversions, even when both pass a range check. Use named columns, explicit boundaries and a guarded disposable fixture.
SQLAuthority News – Microsoft SQL Server 2005/2008 Query Optimization & Performance Tuning Training
We are launching public SQL Server 2005/2008 Query Optimization and Performance Tuning Training in Hyderabad, which I will lead, with a computer for everyone.
Keeping Up With SQL Server Without Drowning
Make keeping up SQL Server knowledge manageable with release-note reviews, one deep topic each quarter, and a small record of relevant changes.
geometry STCrosses: Crossing Depends on the Intersection Dimension
geometry STCrosses uses the dimension and interior position of the intersection to define crossing. I compare it with endpoint contact and collinear overlap. A shared point or segment does not automatically satisfy that definition.
Correlated Columns and Multi-Column Statistics in SQL Server
Investigate multi-column statistics with correlated city and state values, density vectors, and plans before expecting better estimates.