×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

目前最火的ChatGPT的费用估算,完了,完全看不懂,感叹科技进步

Report

Replies, comments and Discussions:

  • 工作学习 / 学科技术 / 目前最火的ChatGPT的费用估算,完了,完全看不懂,感叹科技进步
    • 今天晚上小朋友才和我聊這個,語音輸入你的要求(比如某種型式最佳的室內設計),ChatGPT就直接畫出完整設計的2個方案,的確不少年輕人在談論
      • google 居然在这方面被OpenAI 这样的小团队碾压,难以想象。
    • 注册了一个账号,有意思
    • 前两天有个帖子human问0收入可取多少RRSP, 得到AI回答$2000,就是chatgpt干的吗?看来它还有很长的路要走。逗逗它可以,别都信 +3
      • 其中的business intelligence需要不断地调整和维护,哪里会便宜
        • 人机结合是另一出路。马思克搞的那个
      • 记得哪家的AI chat 还劝人自杀呢
    • 有啥看不懂的?智能游戏而已,谁敢信它的结果才怪。自动生成一堆东西,你得花时间去确认。 +2
    • 我测试了几个database问题, 比google 更直接而且准确。example inside: +1

      Me: does microsoft sql server put page lock on update or merge statement? why not row level lock?

      ChatGPT:

      Microsoft SQL Server uses locks to help ensure the integrity of data when multiple users are accessing the database simultaneously. The type of lock that SQL Server uses depends on a variety of factors, including the type of query being executed and the state of the data being accessed.

      In general, SQL Server uses page locks when performing update or merge operations. Page locks apply to an entire data page, which is typically 8KB in size. This means that any update or merge operation that affects data on a particular page will result in a page lock being placed on that page.

      One reason why SQL Server uses page locks for update and merge operations is that these operations often affect multiple rows of data. If SQL Server were to use row-level locks in these cases, it would have to place a separate lock on each individual row, which could potentially result in a large number of locks being placed on the database. This could cause performance issues and make it difficult for SQL Server to manage the locks effectively.

      Another reason why page locks are used for update and merge operations is that these operations often require SQL Server to modify data in multiple pages. If SQL Server were to use row-level locks in these cases, it would have to place a separate lock on each individual row, even if those rows are located on different pages. This could result in a large number of locks being placed on the database, which could again cause performance issues and make it difficult for SQL Server to manage the locks effectively.

      Overall, the use of page locks for update and merge operations in SQL Server helps to ensure the integrity of data while also helping to prevent performance issues and manage locks effectively.


      Me: excellent, could you share where did you get the above information?

      I'm sorry, but I am a large language model trained by OpenAI, so I do not have the ability to browse the internet or access external sources of information. All of the information I provide is based on my training on a large corpus of text data, which includes a variety of sources such as books, articles, and websites. I do my best to provide accurate and helpful information based on this training, but I am not able to provide specific sources for the information I provide.

      • SQL server 记不清楚了,查了查。好像有rowlock. 他家的lock escalation倒是挺出名的,别的数据库都没有。
        Locking is essential to successful SQL Server transactions processing and it is designed to allow SQL Server to work seamlessly in a multi-user environment.
    • 今天down 了一天,用不了
    • 做了些测试,挺不错的,可以根据简单的要求写程序了。
    • 小逻辑就让它写了
      • 然后COPY & PASTE。 +1
    • 以后小学生,中学生,大学生作业或者project 能否代做?
      • 能做到辅助,省时间。原来5个小时的考试复习工作量,现在只需三个小时。

        特别是文科科目
        • 😂🌛
    • 可以做SAT 题目了


      :

      • 这答案对吗?74/6余数是2呀!
        • 你很认真,可以当QA.我没仔细测试
          • 这么基本的知识,chatgpt都答错,怎么能指望它帮做作业😜 +1