In Memory Optimized Tables SQL 2014

In Memory Optimized Tables SQL 2014 What are Memory Optimized Tables in SQL Server? Memory Optimized tables are newly introduced in SQL Server and they are fully ACID compliant data storage structures, which stores the data mainly within the system memory(RAM), allowing users to access data very very quickly compared to the stored File system…

What is SQL Server Health Check? Why is it important?

What is SQL Server Health Check? Why is it important? A SQL Server health check looks at all aspects of your SQL Server environment in terms of best practices in the areas of Performance, Configuration, Security, Disaster Recovery and the ability of your environment to scale to projected future loads. With a SQL Server Health…

Memory configuration and using AWE /3GB /USERVA in SQL Servers 2005/2008 in 64 bit and 32 bit installations