Blog Post

Book Review – SQL Server Internals: In-Memory OLTP – Detailed Notes

,

Here are my unedited chapter notes:

Chapter 1 Chapter 2 Collation – current version requires BIN2 on character index columns. Best to do so at the column level. Supports only sorting, comparison and grouping. Will remove the need for case sensitive code on tables and columns but not data. Collate database_default to handle tempdb collation of temp objects. Research more. Interpreted SQL via interop useful for ad hoc or migration of code.

Original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating