SQL | My Tec Bits

Buffer Pool Extension In SQL Server 2014

Aug 18, 2018Nov 10, 2014 by Beaulin Twinkle

What is Buffer Pool Extension in SQL Server 2014? What is it’s purpose and benefits of using buffer pool extension in sql server?

SQL Server: Joining Tables from Different Databases on the Same Server

Aug 18, 2018Feb 26, 2014 by Beaulin Twinkle

SQL Server Query To Join-Tables From Different Databases

SQL query for joining tables from multiple databases on the same server. Joining tables from different databases in a single select query.

SQL Server 2014: In-Memory OLTP DLLs

Jul 31, 2019Aug 6, 2013 by Beaulin Twinkle

What are In-Memory OLTP DLLs? How are they created? What is the purpose of In-Memory OLTP DLL? Here you have the details about OLTP DLLs.

SQL Server 2014: Compiling Tables and Stored Procedures to Native Code

Jul 31, 2019Aug 5, 2013 by Beaulin Twinkle

What is Native Compilation? How to compile tables and stored procedure to native code? Here are the details of native compilation with examples.

SQL Server 2014: Natively Compiled Stored Procedure

Jul 31, 2019Aug 4, 2013 by Beaulin Twinkle

SQL Server 2014 introduces Natively Compiled Stored Procedure. We will explore it and see the benefits of Natively Compiled Stored Procedure.

SQL Server 2014: Triggers on Memory Optimized Tables

Jul 31, 2019Aug 4, 2013 by Beaulin Twinkle

SQL-Server-2014-Trigger-On-Memory-Table-02

Creating Triggers on Memory Optimized Tables. Is it possible to create triggers on OLTP In-Memory optimized tables? Steps to create memory optimized tables.

SQL Server 2014: Non-Durable Table

Aug 18, 2018Jul 25, 2013 by Beaulin Twinkle

SQL-Server-2014-Create-In-Memory-Tables-02

In SQL Server 2014, Non-Durable Table is a kind of memory optimized table, which can handle In-Memory OLTP. Some brief details about Non-Durable Table.

SQL Server 2014: In-Memory OLTP Optimized Tables

Jul 31, 2019Jul 24, 2013 by Beaulin Twinkle

Salient features of In-Memory OLTP Optimized Tables.

Durable Table In SQL Server 2014 – Create Durable Table

Aug 18, 2018Jul 20, 2013 by Beaulin Twinkle

SQL-Server-2014-Create-In-Memory-Tables-01

What are Durable Tables? How to create durable table In SQL Server 2014? Durable Table is a kind of memory optimized table, which can handle In-Memory OLTP.

SQL Server 2014: Creating Table Optimized for In-Memory OLTP

Aug 18, 2018Jul 19, 2013 by Beaulin Twinkle

How to create a table optimized for In-Memory OLTP to use the memory optimizations introduced in SQL Server 2014. Creating In-Memory OLTP table.

SQL Server: Does WITH (NOLOCK) increase performance?

Jul 31, 2019Jun 28, 2013 by Beaulin Twinkle

Does with (nolock) increase performance in T-SQL Queries? Can you increase the performance of SQL queries by adding WITH NOLOCK? Lets find out.

Case Sensitive String Comparison on SQL Server

Jul 31, 2019Jun 22, 2013 by Beaulin Twinkle

How to do a case sensitive string comparison on SQL Server using COLLATE. Case sensitive comparison in SQL Server 2008, SQL Server 2012, SQL Server 2014.

SQL Server Case Sensitive Search: Fetching lowercase or uppercase string

Jul 31, 2019Jun 21, 2013 by Beaulin Twinkle

How to fetch lowercase or uppercase or mixed case, case sensitive string in SQL Server. Case sensitive search using select query. There are two simple ways .