Types Of Pages in SQL Server
1. Data pages - contain the actual data stored in the database.
2. Index pages - contain index data used to speed up query processing.
3. Allocation pages - keep track of the pages allocated to different database objects.
4. Global Allocation Map (GAM) pages - keep track of the free and used extents in a database.
5. Shared Global Allocation Map (SGAM) pages - keep track of mixed extents in a database.
6. Bulk Changed Map (BCM) pages - keep track of pages that have been modified by bulk operations, such as a large insert or update.
7. Differential Changed Map (DCM) pages - keep track of pages that have been modified since the last full backup
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
1. Data pages - contain the actual data stored in the database.
2. Index pages - contain index data used to speed up query processing.
3. Allocation pages - keep track of the pages allocated to different database objects.
4. Global Allocation Map (GAM) pages - keep track of the free and used extents in a database.
5. Shared Global Allocation Map (SGAM) pages - keep track of mixed extents in a database.
6. Bulk Changed Map (BCM) pages - keep track of pages that have been modified by bulk operations, such as a large insert or update.
7. Differential Changed Map (DCM) pages - keep track of pages that have been modified since the last full backup
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
🔥2👍1🎉1
Check out this job at Canonical: https://www.linkedin.com/jobs/view/3441080629
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
👍3🔥1🐳1💊1
❎Go Proverbs
Don't communicate by sharing memory, share memory by communicating.
Concurrency is not parallelism.
Channels orchestrate; mutexes serialize.
The bigger the interface, the weaker the abstraction.
Make the zero value useful.
interface{} says nothing.
Gofmt's style is no one's favorite, yet gofmt is everyone's favorite.
A little copying is better than a little dependency.
Syscall must always be guarded with build tags.
Cgo must always be guarded with build tags.
Cgo is not Go.
With the unsafe package there are no guarantees.
Clear is better than clever.
Reflection is never clear.
Errors are values.
Don't just check errors, handle them gracefully.
Design the architecture, name the components, document the details.
Documentation is for users.
Don't panic.
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
Don't communicate by sharing memory, share memory by communicating.
Concurrency is not parallelism.
Channels orchestrate; mutexes serialize.
The bigger the interface, the weaker the abstraction.
Make the zero value useful.
interface{} says nothing.
Gofmt's style is no one's favorite, yet gofmt is everyone's favorite.
A little copying is better than a little dependency.
Syscall must always be guarded with build tags.
Cgo must always be guarded with build tags.
Cgo is not Go.
With the unsafe package there are no guarantees.
Clear is better than clever.
Reflection is never clear.
Errors are values.
Don't just check errors, handle them gracefully.
Design the architecture, name the components, document the details.
Documentation is for users.
Don't panic.
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
👍6🔥1
کتاب رایگان آنلاین برای یادگیری نکات برنامه نویسی سیستمی
github.com/angrave/SystemProgramming/wiki
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
github.com/angrave/SystemProgramming/wiki
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
GitHub
Home
Angrave's Crowd-Sourced System Programming Book used at UIUC - angrave/SystemProgramming
❤4👍1
❎Go’s map hashes strings with CPU AES instructions
📡 https://github.com/golang/go/blob/master/src/runtime/asm_amd64.s#L955
〽️ if your processor has them, which it probably does.
cat /proc/cpuinfo | egrep 'aes|sse2|sse4_1' will tell you.
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
📡 https://github.com/golang/go/blob/master/src/runtime/asm_amd64.s#L955
〽️ if your processor has them, which it probably does.
cat /proc/cpuinfo | egrep 'aes|sse2|sse4_1' will tell you.
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
👍2
❎Go: Slice search vs map lookup
https://darkcoding.net/software/go-slice-search-vs-map-lookup/
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
https://darkcoding.net/software/go-slice-search-vs-map-lookup/
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
👍5
What is WAL? (Write-ahead log) — A deep dive
https://medium.com/@hnasr/what-is-wal-write-ahead-log-a-deep-dive-a2bc4dc91170
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
https://medium.com/@hnasr/what-is-wal-write-ahead-log-a-deep-dive-a2bc4dc91170
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
Medium
Why databases need Write-ahead log (WAL) — A deep dive
Foundational principal of any durable database system
👍2🐳2
❎برنامه نویس بلاکچین (Solidity)
https://jobvision.ir/jobs/409464/استخدام-برنامه-نویس-بلاکچین-solidity
❎برنامه نویس بلاکچین (Solidity)
https://jobvision.ir/jobs/410540/استخدام-برنامه-نویس-بلاکچین-solidity
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
https://jobvision.ir/jobs/409464/استخدام-برنامه-نویس-بلاکچین-solidity
❎برنامه نویس بلاکچین (Solidity)
https://jobvision.ir/jobs/410540/استخدام-برنامه-نویس-بلاکچین-solidity
➖➖➖➖➖➖➖➖➖
🔰 @gopher_academy
💊2
💊3