A reader, Virendra Chauhan, shared a UDF that removes duplicate chars from one large string. Here is his REMOVE_DUPLICATE_INSTR function and how to call it.
ReorientObject: Swap a Geographic Ring’s Interior
ReorientObject swaps a geography polygon’s interior and exterior. Compare inside and outside witnesses, then reorient twice to restore membership.
OR in a JOIN: Preserve Matching Pairs When Rewriting
OR in a JOIN matches either key while returning each pair once. Compare NULL cases and pair counts before rewriting. Measure the actual plan only after proving the results.
SQL SERVER – Q and A with Database Administrators
My Q and A with Database Administrators from interviews in India: the technical questions we discussed and my opinion on each, with a link to the full article.
STPointOnSurface: Choose a Point Inside a Polygon
STPointOnSurface returns an interior point. Check a polygon with a hole, a simple polygon and an empty geometry without assuming exact coordinates.
Finding the Right System View for the Question You Have
Choose SQL Server system views by the question they answer, distinguish catalog metadata from runtime counters, and understand reset boundaries.
AND and OR: Parentheses Make Predicate Precedence Clear
AND and OR predicates need explicit grouping. Use a complete small truth table to expose which alternatives share a common requirement.
SQL SERVER – Correct Syntax for Stored Procedure SP
What is the correct syntax for stored procedure code? Anything between BEGIN and END is part of the procedure, and anything after GO is not, as my examples show.
SQL SERVER – 2005 – List All Stored Procedure in Database
Want to see all stored procedure in database at once? Run SELECT * FROM sys.procedures. This simple query works only with SQL Server 2005.
SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
What is Third Normal Form and what is its advantage? I ask this in every interview I take. Here are the rules of 3NF and its cost in performance.