ATN2 uses two components to calculate an angle while retaining its quadrant. I keep the argument order and angle unit visible. Dividing one component by the other would lose useful information and introduce a zero-denominator case.
SQL SERVER – Rollback TRUNCATE Command in Transaction
Many believe TRUNCATE cannot be rolled back. It can. Here is a Rollback TRUNCATE command example inside a transaction, and why TRUNCATE is logged.
SQL SERVER – Performance Comparison – INSERT TOP (N) INTO Table – Using Top with INSERT
A Performance Comparison of INSERT TOP (N) INTO a table versus INSERT with SELECT TOP (N). The first is clearly faster, but the two can give very different results.
QUOTENAME Object Names: Quote Each SQL Server Name Part
QUOTENAME object names separately to keep each part of a qualified SQL Server name intact. The function surrounds its entire input with identifier delimiters. A dot inside that input stays inside one quoted name. I keep the schema and object in separate variables.
SQL SERVER – Introduction to Rollup Clause
An introduction to the Rollup Clause in SQL Server, which aggregates at several levels of a hierarchy. A population table by country, state and city shows how.
Data Mining Algorithms (Analysis Services – Data Mining)
I quite often receive requests for the Data Mining Algorithms details. Book Online has wonderful resources for the same. I suggest to read them here.
geometry STOverlaps: Intersection Alone Is Not Enough
geometry STOverlaps asks a narrower question than whether two shapes share any points. I test equal and contained regions alongside a partial overlap. Those intersecting cases do not all satisfy the method’s overlap definition.