-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Born SQL with Randolph West

Randolph West solves technology problems with a focus on SQL Server and C#. He is a Microsoft Data Platform MVP who has worked with SQL Server since the late 1990s. When not consulting, he can be seen acting on the stage and screen or doing voices for independent video games.

Archives: February 2018

Dates and Times in SQL Server: SMALLDATETIME

Last week I spoke about a world wary data type for storing dates and times in a single column, with a granularity of three milliseconds, DATETIME. But let’s say you don’t need that kind of accuracy and are happy with a granularity to the nearest minute. Maybe you’re storing time… Read more

2 comments, 795 reads

Posted in Born SQL with Randolph West on 28 February 2018

Dates and Times in SQL Server: DATETIME

Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the basics of various date and time data types in SQL Server, when to use them, and which functions to use for date and time calculations. This week will start with… Read more

0 comments, 250 reads

Posted in Born SQL with Randolph West on 21 February 2018

Why nested views are bad

Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you have a SELECT statement you tend to use all over the place (a very common practice when checking user permissions). There are five base tables in the join, but it’s… Read more

3 comments, 1,714 reads

Posted in Born SQL with Randolph West on 14 February 2018

Help the fight against cancer

Tom Roush The SQL Family lost a much admired member to cancer last month, Tom Roush. In our little community, Tom was a well-known raconteur who wrote around a hundred stories, many of which were published on his blog. He was working on a book containing the best of these… Read more

0 comments, 297 reads

Posted in Born SQL with Randolph West on 7 February 2018