SQL Tact

Thursday, March 21, 2013

TRY_CONVERT broken by WITH SCHEMABINDING in SQL Server 2012 Data Tools build

›
Here's a bug you might find if attempting to schemabind an object that uses the new TRY_CONVERT function. To reproduce, run the follow...
Friday, March 08, 2013

Conversation History: The Continuing Case Against GUIDs

›
We had a cooperative relational database design exercise at the office last week as part of our regular department "Lunch and Learn...
Friday, March 01, 2013

YYYYMM Math

›
I had a project recently where I had to do math on a number that represented a date, YYYYMM. For example, February 2013 would be stored as...
‹
›
Home
View web version
Powered by Blogger.