AT TIME ZONE way too slow - by Robert L Davis

Status : 

 


43
1
Sign in
to vote
ID 3144414 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 11/24/2017 6:58:23 AM
Access Restriction Public

Description

AT TIME ZONE shells out to Windows to perform time zone conversions. This process takes way too long when working with more than a few rows (see this blog post for details: http://sqlsoldier.net/wp/sqlserver/timezonesareadragseriously). The time zone info does not change frequently. The info from Windows required to make the conversions should be cached within SQL Server to speed up this processing.
Sign in to post a comment.