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 TSQL Table Variables

Table Variables In SQL Server: These tables behave very much like other variables in their scoping rules. They are created when they are declared and are dropped when they go out of scope. They cannot be explicitly dropped. Like with temp tables, table variables also reside in TempDB. They are also generally accessed only from…

SQL Server TSQL Temporary Table

Temp tables in SQL Server: 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…

SQL Server Database Mail Configuration Step by Step

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…

Temporary Variables vs Temporary Tables SQL Server 2008/2005

SSRS Queries for a DBA or Developers to monitor Reporting Server

The Script to Check Reports and Subcriptions with Sorted results per last Run Date SELECT c.Name AS ReportName , rs.ScheduleID AS JOB_NAME , s.[Description] , s.LastStatus , s.LastRunTime FROM ReportServer..[Catalog] c JOIN ReportServer..Subscriptions s ON c.ItemID = s.Report_OID jOIN ReportServer..ReportSchedule rs ON c.ItemID = rs.ReportID AND rs.SubscriptionID = s.SubscriptionID order by 5 To Check Latest…

Parameter Sniffing in Stored Procedures in SQL Server 2008/2008 R2

Parameter Sniffing in Stored Procedures in SQL Server 2005/2008/2008 R2 Today let me cover one of a good topic on Parameter Sniffing in Stored Procedures: Paramater Sniffing is not a unexpected behaviour when passing parameters into Store Procedure. CREATE procedure [dbo].[Usp_Test_SP] @Category as [nvarchar](60)=null as select Category ,Description,WorkOrder,Date Added from TestTable where (sc.session_class_desc like @Category…