Subscribe to this blog
Archives: December 2012
On the Advantages of DateTime2(n) over DateTime
Starting with SQL 2008, we database developers started becoming more familiar with datetime2. Sometimes folks need convincing though, so here goes.
Here's a brief review of how the precision of the datetime2 data type converts from a varchar representing a time value out to one ten-millionths of a second. Run…
Here's a brief review of how the precision of the datetime2 data type converts from a varchar representing a time value out to one ten-millionths of a second. Run…
0 comments, 476 reads
Posted in SQL Tact on 4 December 2012
Management Studio Database Diagram Owners
If you're working in an environment as a developer without sysadmin privileges, and you are creating database diagrams using Management Studio underrated diagram tool, but not the database owner or a sysadmin, you'll see your created diagrams look like this
where the diagram is owned by the developer using the sql…
0 comments, 1,132 reads
Posted in SQL Tact on 3 December 2012