SQL Server 2014 – Limitation of Memory optimized tables

Every good things has some its pros and cons, so here are some of the limitions of In-Memory optimized tables in SQL Server 2014 Limition of Memory optimized tables Tables used in In-Memory OLTP feature of SQL Server 2014 are known as Memory optimized tables, SQL Server 2014 has some limitions for memory optimized tables Some datatypes ...

SQL Server 2014 – New Feature In-Memory OLTP Engine

SQL Server 2014 introduced many features to improve performance OLTP transactions, In-Memory OLTP is one of the most exciting feature in SQL Server 2014 which allows to move individual tables to special in-memory structures to improve query perfomance. What is In Memory OLTP Engine of SQL Server 2014 ? This is better than other in-memory solutions that require the ...

Start and Stop SQL Server Services using Command prompt

There are number of different ways to Start and Stop SQL Server services, you can using SQL Server Configuration Manger, SQL Server Mangement Studio, Sqlserver.exe, Command prompt and Windows Console . We will see how to start and stop SQL Server using Command Prompt. You can use Net Start and Net Stop command to Start and ...

Difference in Features of SQL Server 2012 Vs SQL Server 2014

SQL Server 2012 vs 2014 There are lots of new features added in SQL Server 2014 to improve query performance, main difference between SQL Server 2012 and SQL Server 2014 are listed in this article. * SQL Server 2012 supports upto 64 GB RAM, SQL Server 2014 supports 4 TB RAM. * SQL Server 2012 ...

SQL SERVER – Select Best Recovery Model for your database

Recovery model for sql server database is depends on customer requirement, SQL Server supports three recovery models, Full recovery, Simple recovery and bulk-logged recovery. Recovery models tells you whether How much data loss is acceptable by customer. SIMPLE RECOVERY If your database is not critical and Data loss is accepable by client after last full or differential backup than ...

SQL Server 2014 – Different Editions

Different Editions of SQL SERVER 2014 Select best SQL Server 2014 Editions for your environment to improve your business. Enterprise Edition SQL Server Enterprise delivers comprehensive high-end datacenter capabilities for demanding database and business intelligence requirements. Business Intelligence Edition SQL Server Business Intelligence empowers organizations to build and deploy secure, scalable and manageable self-service corporate BI solutions. Standard Edition ...

SQL Server 2012 -How to setup new Availability Group and Listener

Steps to setup new Availability Group and Listener in SQL 2012 Follow the below steps by step approach to setup new Availability Group and Listener using powerShell Script in SQL Server 2012. 1. Before starting ensure that you have the AG name, listener name and IP address ready. 2. On a new instance, endpoint need to be created. ...

SQL SERVER 2014 – New features

  New features in SQL Server 2014 It introdue lots of new features to improve performance 40 times better compare to older version of SQL Server for heavy workload queries. Top features of SQL Server 2014 are listed below. In-Memory OLTP Engine You can store tables and stored procedure in memory to improve query peformance, This ...

SQL Server – Transaction log for database ‘tempdb’ is full due to ACTIVE_TRANSACTION

Tempdb is full due to active transaction Tempdb database is part of SQL Server System database and gets created every time SQL Server Service starts. Tempdb stores temporary operations (like sorting and grouping data output etc) and tables, it stores lots of  information in cache to improve query performance in sql server. Whenever transaction log for ...

SQL Server Error – Cannot resolve collation conflict for equal to operation

Resolve collation conflict error in SQL Server This error comes up when you try to compare two different collation column in the query. To resolve collation conflict error you can use COLLATE DATABASE_DEFAULT option while comparing two different collation in select query. In my case, if I run the below select query in SQL Server using SSMS.  It ...