A quick introduction to the PARSE function in SQL Server Denali: convert a string to a number or a date and time, and see what happens when it fails.
What a Preview Build Is For, and What It Is Not
Use a SQL Server preview to test specific features and report reproducible issues while keeping production data and recovery paths separate.
AT TIME ZONE Cost: Converting Many Rows Without Burning CPU
Converting a whole column with AT TIME ZONE looks harmless on three rows and hurts on a hundred thousand. Here is the cheaper way to filter a local day.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – OpenXML Options – Day 35 of 35
OpenXML options explained: rowpattern recursion to search lower levels of your XML, and column patterns to reach one level higher, with a manager example.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Preparing XML in Memory – Day 34 of 35
Before you can turn XML into a result set, SQL Server needs it in memory. Here is how preparing XML in memory works, with a customer order example.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Shredding XML – Day 33 of 35
After streaming table data into XML, we go the other way. Shredding XML means turning XML data back into rows and columns that you can query.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 32 of 35
Beyond using root with Auto XML mode, the XML Path mode lets you show some data as attributes and some as elements. Here is how, with JProCo data.