Microsoft SQL Server Error: 53 or Microsoft SQL Server Error: 11001 or SQL Server error 53 and 40. SQL server error 53 and 17

SQL Server Memory & Storage Technology

SQL Server- Understanding Server Storage Technology Explained First we need to understand the different types of memory below a.Static random access memory (SRAM) comprising L1 and L2 caches for each physical core of a processor,larger but slower shared L3 cache for the entire processor. b. Dynamic random access memory (DRAM) which also our RAM we…

SQL Server 2016 New Features In-Memory OLTP enhancements

SQL Server 2016 New Features In-Memory OLTP enhancements 1. SQL Server In-Memory OLTP – Parallel and heap scan for memory-optimized tables Memory-optimized tables and indexes in In-memory optimized tables are supported to parallel scan. This improves the performance of queries. Heap scan is also supported which can be performed in parallel which is scanning of…

Setup R Services for SQL Server 2016 Step by Step Explained

Setup R Services for SQL Server 2016 Step by Step Tutorial Microsoft purchased Revolution Analytics (around 2015) and with that they were able to give R Services which is the most popular open source programming language for advanced analytics of data inside of SQL Server bringing R processing closer to the data.. By adding R…

SQL Server Database Mail Configuration Step by Step

SQL Server 2014 Compared to older versions

  SQL Server 2014 Compared to older versions     Features Feature Description SQL Server 2014 SQL Server 2012 SQL Server 2008ÿR2 SQL Server 2008 Performance In-memory OLTP* Yes No No No In-memory ColumnStore* Yes Yes No No Buffer pool extension to SSD Yes No No No Resource Governor Yes Yes Yes Yes Availability AlwaysOn*…

SQL Server 2014 released..New features

SQL Server 2014 released… Let’s discover what’s new in SQL Server 2014 now. There are versions in SQL Server out of which Express version is still free . Download SQL Server from Microsoft Site or your company volume licensing depending on your version you require. New features will be listed here which are really fantastic…. Note: Database…

CTE vs Temp Table vs Temp variables

Temp tables: they are just like any normal tables except that they are created in the TempDB database. They persist until dropped, or until the connection that created them disappears. They are visible in the procedure that created them and any procedures that it calls. Just like normal tables and have primary keys, constraints, indexes…