Database Reference
In-Depth Information
Figure 23-12. Table Memory Optimization Advisor showing all the unsupported data types
That means this table, as currently structured, would not be a candidate for moving to in-memory storage. So that
you can see a clean run-through of the tool, I'll create a clean copy of the table in the InMemoryTest database created
earlier, shown here:
USE InMemoryTest;
GO
CREATE TABLE dbo.AddressStaging
(
AddressID INT NOT NULL
IDENTITY(1, 1)
PRIMARY KEY,
AddressLine1 NVARCHAR(60) NOT NULL,
AddressLine2 NVARCHAR(60) NULL,
City NVARCHAR(30) NOT NULL,
StateProvinceID INT NOT NULL,
PostalCode NVARCHAR(15) NOT NULL
);
 
Search WWH ::




Custom Search