SQL Server 2016 takes this one level further and lets you transform JSON data in table rows. This ability might save a lot of work and CPU cycles off your code as now you can push the raw JSON text to ...

In an earlier column, I showed how to create a temporal table in SQL Server 2016 or Azure SQL Database. Once you've defined a temporal table, SQL Server automatically keeps a history of all the ...

SQL Server 2008 provides a minimal set of tools — cursors and WHILE loops — to accomplish this task. I’ll take a closer look at each option and explain why it’s difficult to pinpoint which ...