08 2021 档案

SQL SERVER Performance capabilities
摘要:Memory, CPU, and I/O capacities Indexes In-memory OLTP(Online transaction processing) Partitions A common technique for SQL Server performance trouble 阅读全文

posted @ 2021-08-19 17:09 格物致知2019 阅读(36) 评论(0) 推荐(0) 编辑

Azure SQL Storage
摘要:If you reach the maximum storage, you might get Message 1105 for a managed database or Message 1133 for the instance. Just like SQL Server, the size o 阅读全文

posted @ 2021-08-13 16:19 格物致知2019 阅读(43) 评论(0) 推荐(0) 编辑

T-SQL quries
摘要:SELECT @@VERSION; SELECT SERVERPROPERTY('EngineEdition'); 1 = Personal or Desktop Engine 2 = Standard 3 = Enterprise 4 = Express 5 = SQL Database 6 = 阅读全文

posted @ 2021-08-12 17:30 格物致知2019 阅读(31) 评论(0) 推荐(0) 编辑

导航