Here is choice of links for this week. SQL Server: Phil Factor’s Primary Key Primer for SQL Server is an excellent primer on choosing primary keys for SQL Server databases. It also includes links to several related and relevant resources. Brent Ozar’s The Secrets of TempDB is a very interesting video on TempDB, one of SQL Server’s...
Tag: OLTP
Post
My links of the week – October 27, 2013
Here are my favorite links from the last week, on SQL Server, database design and web design . There are a few great articles on Hekaton, its advantages, compromises and even a guide on how to convert stored procedures to take advantage of its huge performance improvement. Merrill Aldrich’s Why Hekaton In-Memory OLTP Truly...