-->
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: May 2018

Dates and Times in SQL Server: the problem with DATETIME

Recently I wrote a post about date and time functions you should never use, which contained an opinion I’ve expressed previously that some people have disagreed with, namely that DATETIME is a terrible data type which you should not be using in new development. The motivation for this position is… Read more

1 comments, 270 reads

Posted in Born SQL with Randolph West on 30 May 2018

Virtual Log Files: 200 or 1000?

Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During the follow-up meeting, the senior DBA and I had a discussion about Virtual Log Files (VLFs), disagreeing on the maximum number of Virtual Log Files a transaction log should have.… Read more

1 comments, 417 reads

Posted in Born SQL with Randolph West on 23 May 2018

Dates and Times in SQL Server: more functions you should never use

Previously we looked at four built-in functions to get the current date and time in SQL Server and Azure SQL Database using Transact-SQL (T-SQL). We identified that out of the options provided, SYSUTCDATETIME() is the recommended method because it relies on Coordinated Universal Time (UTC), and uses the DATETIME2 data… Read more

10 comments, 3,778 reads

Posted in Born SQL with Randolph West on 16 May 2018

A big thank you

Thank you! Thank you for reading my blog. Thank you for buying my book. Thank you for attending my sessions at SQLSaturdays and SQLBits. Thank you for providing session feedback to help me improve. Thank you for commenting on my posts, especially when I get things wrong. Thank you to… Read more

0 comments, 211 reads

Posted in Born SQL with Randolph West on 9 May 2018

Dates and Times in SQL Server: What about TIMESTAMP?

It occurred to me that we haven’t covered the TIMESTAMP data type in this series about dates and times. TIMESTAMP is the Windows Millennium Edition of data types. It has nothing to do with date and time. It’s a row version. Microsoft asks that we stop calling it TIMESTAMP and… Read more

2 comments, 209 reads

Posted in Born SQL with Randolph West on 2 May 2018