Tag: in-memory

SQL Server

Understanding Database Indexes — (Part – 3)

by

Understanding Database Indexes – (Part – 3) Author: Basit A. Farooq Full-text indexes A full-text search is a word search based on character string data. The Microsoft Full-Text Engine for SQL Server creates and maintains a full-text catalog automatically when you enable a table for full-text search. For more information about full-text indexes, see SQL Server Books Online topic: “Populate […]

Continue Reading →
SQL Server

Understanding Database Indexes — (Part – 2)

by

Understanding Database Indexes – (Part – 2) Author: Basit A. Farooq Covering Index with included columns SQL Server 2005 introduces included columns in indexes also known as covering indexes. Included columns are non-key columns. Query performance improves when all columns in a query are included in the index as either key or non-key columns. The SQL Server Database Engine stores […]

Continue Reading →
Pro Members SQL Server Standard Members

Tips for using stored procedures in SQL Server 2014

by

Tips for using stored procedures in SQL Server 2014 Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables or DDL statements inside stored procedure reduces the chance to reuse the execution plan. Call stored procedure using its fully qualified name. The complete name of an object consists of four identifiers:...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Memory management for In-Memory OLTP Server – Part 1

by

Memory management for In-Memory OLTP Server Part-1 Microsoft introduced a new functionality in SQL 2014 namely memory optimized objects. As the name implies, this technology is about having tables reside in memory. This means that the memory usage on your database will be much higher. In this series of articles we will see how we can manage the memory in...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →