SQL Server 2012 was released last April, making it the 11th major release of the product. Every new version has delivered new functionality that should excite developers, and this release is no ...

Building on the DATETIMEFROMPARTS, DATETIME2FROMPARTS offers similar functionality, but yields more precise DateTime2 data type, containing fractions of a second to a specified precision. Naturally, ...

Making your T-SQL work smarter for you by having it work as a code generator. Part 1 in a series. Want to save some time writing code? Many DBAs use the trick I'm going to show you this week to: A) ...