Free eBook: SQL Server Internals: In-Memory OLTP

In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible.

Pages I

Numeric Data Types

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.

Inside the Optimizer: Constructing a Plan - Part 4

The final part in a series by Paul White exploring the internals of query optimization. Learn how

Inside the Optimizer: Constructing a Plan - Part 3

Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.

Inside the Optimizer: Constructing a Plan - Part 2

How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.

Inside the Optimizer: Constructing a Plan - Part 1

Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.

Replication process

I need to replicate a database where some tables are created dynamically each morning.The process involves a group of records in a primary table where the accounts stored in this table need to be contacted for discussion of payment status.These records are selected into different groups (the dynamic tables) based on varying criteria.  These dynamic tables are […]

RE: image files

Hmmmm, ok, but where am I when I'm saving this file?  I need to create a vb interface to save the file to the table.  do I hook this code to a command on my form?  Where does the image actually tie in?  Should I save it first to a file on my hard drive […]