-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Dennis's SQL Blog

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 discussed about using memory optimized tables to replace table variable and global temp table, this time we will replace local temp tables and seek for performance gain. We all use…

Read more

8 comments, 4,111 reads

Posted in Dennis's SQL Blog on 21 February 2017

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

Follow my last post which can be found 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/), we discussed about replacing table variable by memory optimized table, this time we will look at another use case - global temp table.

The main idea here is to replace temp tables, where those data does not needs to…

Read more

2 comments, 4,184 reads

Posted in Dennis's SQL Blog on 8 February 2017

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

There are many cases where you will be using temp tables, and many of us are trying to seek for performance improvement. Fortunately with SQL 2016, we now have a way to do it via memory optimized tables!

There are different usages of temp tables, most commonly is table variables ,…

Read more

5 comments, 5,386 reads

Posted in Dennis's SQL Blog on 1 February 2017

Nolock vs snapshot isolation

We all experienced blocking one way or the other, in the old days, the only method is wait J

This is not entirely true you might say, as you can always change the code to include nolock table hint so that it can perform a dirty read. Yes, that seems…

Read more

3 comments, 2,702 reads

Posted in Dennis's SQL Blog on 16 January 2017

Knowledge vs Ability

Knowledge and ability, they are very inter-related. We born with only survival ability, ability to eat and drink, that’s pretty much about it. After that we started to gain knowledge through learning, and become ability, through school to learn language, mathematics, programming etc. But having knowledge doesn’t mean we have…

Read more

0 comments, 486 reads

Posted in Dennis's SQL Blog on 7 November 2016

SQL Live Health Check - part 3 - permission requirements and the rest

This is the last part of the series, where I discuss about the monitoring application that I build. If you would like to know how it works, please see the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2016/09/30/say-hello-to-sql-live-health-check-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2016/10/05/sql-live-health-check-part-2-historical-data-and-configuation/).

If you have already downloaded the application and tried…

Read more

0 comments, 929 reads

Posted in Dennis's SQL Blog on 12 October 2016

SQL Live Health Check - part 2 - historical data and configuation

In the previous post (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2016/09/30/say-hello-to-sql-live-health-check-part-1/) I talk about the main screen where you can have a single glance of the healthiness of all your db instances, clear color-coded for issues occurring at the time. You might ask, whats about trends, how can I change threshold..... This post is…

Read more

0 comments, 869 reads

Posted in Dennis's SQL Blog on 5 October 2016

Say hello to SQL Live Health Check - part 1

When you need to manage a number of SQL instances, monitoring them becomes one of your priority task. In some large environment, you might have some third party tools to help you do that. System Center suite have Operation manager (SCOM) which can helps you monitor servers along with SQL…

Read more

0 comments, 1,237 reads

Posted in Dennis's SQL Blog on 30 September 2016

SQL Server 2016 - Are you ready for upgrade?

SQL Server 2016 has been officially launched for a little more then three month, many people are feeling excited to check if they should upgrade. In fact, many DBA should already played with it for awhile as the CTP has been around for sometime before the actual launch date, there…

Read more

0 comments, 754 reads

Posted in Dennis's SQL Blog on 6 September 2016

SQL Server Basic - Memory

For those of you who just started to manage SQL server might wonder why SQL server use so much memory. After you do some research online, you normally will see response saying SQL server is memory hungry and by default will take all your memory! You need to configure to…

Read more

1 comments, 532 reads

Posted in Dennis's SQL Blog on 8 July 2016

I am a Microsoft Data platform MVP

I am so excited and happy to be chosen to receive the Microsoft Data Platform MVP award. This is my first time obtaining this award and the news comes via an email in the late evening on the 1st July, it is a great honor to be given this award.…

Read more

0 comments, 347 reads

Posted in Dennis's SQL Blog on 4 July 2016

SQL Server 2016 available today

In case you haven't heard, SQL server 2016 is generally available today! If you haven't try it out, you should start play around with it. There are many new features that I will discuss in details in later posts. For more information, you can refer to the SQL blog: https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/

Read more

0 comments, 687 reads

Posted in Dennis's SQL Blog on 2 June 2016

StorSimple Appliance – Part 1 Overview

Last time, I talked about cloud backup and the two different ways of doing it – directly and using StorSimple appliance (which you can find here and here). I notice some others are looking at the same and would like to share more information on this device and the test…

Read more

0 comments, 1,326 reads

Posted in Dennis's SQL Blog on 19 May 2016

End of Support - SQL Server 2005

It finally comes to this date, 12th April 2016, the end of support for SQL server 2005! SQL 2005 is with us for 10 years, its one of the major upgrade from SQL 2000 and is one of the major step that bring SQL to success. Everything has its ends…

Read more

0 comments, 446 reads

Posted in Dennis's SQL Blog on 12 April 2016

Cloud backup - MS StorSimple Applicance

In the previous post, I talked about how we can revamp the backup infrastructure for SQL to backup directly to Azure, you can find the post here. I also mention that there might be some concerns to backup directly to cloud where the backup to URL statement doesn’t support keep…

Read more

3 comments, 1,954 reads

Posted in Dennis's SQL Blog on 11 April 2016

Cloud Backup - Directly to Azure

Backup is one of the major task for DBAs, it has many different options and ways for each companies to perform their backup according to their needs (RPO and RTO). However, many of them are having the same issues, which is where can I keep my backup files which allow…

Read more

0 comments, 1,354 reads

Posted in Dennis's SQL Blog on 7 April 2016

SQL server on Linux

Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full launch for mid-2017. You can find the official blog here. If you like to sign up for the preview, you can apply here.
I assume that is the logical…

Read more

5 comments, 2,033 reads

Posted in Dennis's SQL Blog on 9 March 2016

Installation of SQL Server (Part 2 - Post-installation)

Previously we discussed about the pre-installation consideration, which can be found here. In the second part of this series, we will talk about what we should consider after we got the server setup.
SQL server has been around for a long time, the default setting that comes with it…

Read more

0 comments, 1,305 reads

Posted in Dennis's SQL Blog on 1 March 2016

Installation of SQL Server (Part 1 - Pre-installation)

I have been wanting to write this for a long time, and finally got time to do it. Which is the pre and post configuration of new SQL server installation. Many of configuration was left as default in the hope that Microsoft should already tune it as the baseline for…

Read more

0 comments, 2,284 reads

Posted in Dennis's SQL Blog on 23 February 2016

Trace Flag 3226 - Suppress all successful backups in SQL server error log

SQL server error log contain all information about how a SQL server is running, what is happening and occurring for your databases, it is normally the first place you look at when you have any issue of the database. Keeping it small and as useful as it can be helps…

Read more

0 comments, 6,793 reads

Posted in Dennis's SQL Blog on 8 January 2016

Older posts