Dennis Cheung is a Senior DBA currently living in Hong Kong, he has been working with SQL server since 2000. He has supported a different version of SQL and loves to learn new technology.

Improve performance by replacing temp tables with memory optimized tables - Part 3

Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/08/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-2/).

Previously we...

2017-02-24 (first published: )

4,932 reads

Blogs

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

ADF: Querying JSON documents

By

In my previous blog post I talked about how to read from an XML...

Read the latest Blogs

Forums

Distributed AG DB movement

By Syed_SQLDBA

I have a DAG between On prem and Azure. We have a maintenance window...

object_name (st.objectid) returns NULL. How can I overcome/fix this?

By VoldemarG

How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in...

List all stored procedures which return datasets

By AlexF

Is there any way to do that? I need to list that kind of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers