Understand adaptive joins in SQL Server, read their runtime threshold, inspect the actual choice, and test a query hint safely.
PI: Choose the Precision of a Circle Calculation
PI provides an approximate circle constant. This example keeps radius, circumference and two area calculations together to show when a chosen decimal conversion occurs.
SQL SERVER – Add or Remove Identity Property on Column
There is no direct T-SQL to add or remove the identity property on an existing column. Imran Mohammed shows how SSMS does it and what happens behind it.
SQL SERVER – Example of DDL, DML, DCL and TCL Commands
Simple examples of DDL, DML, DCL and TCL commands: SELECT, INSERT, CREATE, ALTER, GRANT, REVOKE, COMMIT, ROLLBACK and what each one does.
SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009 – Meeting Report
About 50 people came to the Gandhinagar SQL Server User Group Meeting on April 24, 2009 for query optimization tricks and my back to basics talk.
geometry STIntersection: Return the Shared Shape
geometry STIntersection returns the shared shape rather than only an intersection flag. I inspect its type and emptiness alongside its area. A shared edge has zero area but still contains points.
SQL SERVER – Solution to Puzzle – Shortest Code to Perform SSN Validation
My solution to Jacob Sebastian’s puzzle: the shortest T-SQL code for SSN validation that removes invalid SSN values and returns only the valid ones.