SQL Server 2014: Compiling Tables and Stored Procedures to Native Code
What is Native Compilation? How to compile tables and stored procedure to native code? Here are the details of native compilation with examples.
SQL
SQL Server 2014: Natively Compiled Stored Procedure
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
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
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
Salient features of In-Memory OLTP Optimized Tables.
Durable Table In SQL Server 2014 – Create Durable Table
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
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?
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
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
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 .
count(*) or count (1) or count(”) Which is better in SQL server?
SQL Server: count(*) or count (1) or count(”) Which is better? Let’s do an experiment to find the better option among the count.
Does Index Improve SQL Server Query Performance?
Does Index Improve SQL Server Query Performance. Yes Index improves the SQL Server query performance to a large extend. Let’s do an experiment.
MSDB – What is msdb database?
MSDB – What is msdb database in sql server and what is it used for? Id this database important? Where is it located? Can we delete this database?
SP_WHO and SP_WHO2
SP_WHO and SP_WHO2 – Brief description about Microsoft system stored procedures SP_WHO and SP_WHO2. SP_WHO vs SP_WHO2 which one to use when.
Using isnull in where clause is expensive in SQL Server
Using isnull in where clause is expensive in SQL Server. How to avoid useing isnull? Simple way to use case instead of isnull in where clause.