Partitioning tables in SQL Server can dramatically improve query performance, which is a critical aspect of BI. By dividing a large table into smaller, more manageable segments, SQL Server can ...

In SQL Server 2014 there were a number of restrictions on memory-optimized tables: you couldn't alter their structure after they were created; many SQL operators weren't supported (Outer Joins, ...

Reindexing tables is an important part of good database housekeeping, because it reorganizes the indexes and restores speedy access. Microsoft's SQL Server has a handy command that rebuilds all ...

You also don't have to specify a name for your history table, but anonymous tables make me uncomfortable so I've assigned the name SalesOrderHistorical to my table. In Azure SQL Database you can also ...

In this blog entry I will examine my 3 favorite new features that show how SQL Server 2014 provides high-performance OLTP, optimization of business analytics and migration of data to the cloud.