Page 3 of 3 FirstFirst 123
Results 31 to 34 of 34
  1. #31
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,009

    You shouldn't lose any data - DateTime is Slightly less accurate (millisecond level) and than DateTime2
    I believe there ae other subtle differences with the scope of dates covered as well, and storage differences in SQL as well, but nothing that will affect normal Date functions.

    A list of the differences is here https://docs.microsoft.com/en-us/sql...l-server-ver15

    After changing them you may need to refresh the links to update the data type mappings in Access in the front end.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  2. #32
    stildawn is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Oct 2013
    Posts
    185
    Back again

    In regards to Azure SQL, can anyone explain to me what a DTU is as I'm getting conflicting information. I know its a blend of CPU / MEM / Read / Writes etc but:

    Is it:

    1. A measure of the performance of your "server", using a real world example, would a 10 DTU server be a Toyota compared to a 100 DTU server being a Porsche?

    So paying for a higher amount of DTU just increases the performance of your server and thus SQL.


    or


    2. A unit of measurement of computer consumption? A real would example being fuel in a car, I have 10 DTU's worth of server fuel, and each server action uses a little bit and a little bit until I run out? (And thus get charged for the extra)



    Just a bit confused on the whole thing really.

  3. #33
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,009
    It is more like 1. than 2.

    More DTU's is more "compute" power, so more overall Processing power.
    To be honest unless you have a very heavy usage pattern stick to the lowest you can get away with.

    To use your car analogy, 99% of the time the Toyota or the Porsche will bimble along between 30-50mph without any difference.
    Very occasionally you might want to accelerate rapidly to 90Mph for 10 seconds, and one will do a better job than the other, but for the amount of use is it worth the extra $'s, probably not.

    I think we are running about 15 completely separate business use databases on a 100 DTU elastic pool.
    It only hits 100% usage once or twice a week for a few minutes.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  4. #34
    stildawn is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Oct 2013
    Posts
    185
    Ah good, I was hoping it was number 1, yeah the database is small time so we should be fine, might even be able to drop down to 5 DTU when we actually have to pay for it.

Page 3 of 3 FirstFirst 123
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Hosting
    By Perfac in forum Access
    Replies: 1
    Last Post: 09-27-2018, 01:34 PM
  2. Web hosting
    By Perfac in forum Access
    Replies: 2
    Last Post: 05-04-2018, 04:02 PM
  3. DB hosting solutions
    By ahill48 in forum Access
    Replies: 8
    Last Post: 08-20-2017, 10:26 AM
  4. Web Hosting
    By momodoujimnjie in forum Access
    Replies: 1
    Last Post: 09-01-2015, 09:59 AM
  5. Replies: 3
    Last Post: 01-22-2013, 03:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums