Welcome to Sign in | Join | Help

Browse by Tags

All Tags » SQL 2012   (RSS)
SQL Server 2012 installation has the potential to leave an msiexec.exe installer process running after the installation finishes, as described in Windows Installer starts repeatedly after you install SQL Server 2012 SP1: After you install SQL Server 2012 Read More...
SQL Server 2012 SP1 has shipped a great enhancement to XML: Selective XML Indexes. When properly used these indexes can speed up the searching of XML columns tremendously, at little disk/size cost: The selective XML index feature lets you promote only Read More...
With the SQL Server 2012 SP1 CU2 release a new important feature was added: ability to back up and restore a database straight from Azure Blob storage: This feature released in SQL Server 2012 SP1 CU2, enables SQL Server backup and restore directly to Read More...
Columnar storage has established itself as the de-facto option for Business Intelligence (BI) storage. The traditional row-oriented storage of RDBMS was designed for fast single-row oriented OLTP workloads and it has problems handling the large volume Read More...