Log in | Register

SQL Server Internals & Architecture Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education SQL Server Internals & Architecture Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

SQL Server Internals & Architecture

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

SQL Server 2016 – SQL Server checkpoint

Hi Friends,  In today’s blog post we will learn about the importance of SQL Server checkpoint and changes in SQL Server 2016. I’ll start with some basics.

How SQL Server works?

To understand the checkpoint, it’s important to understand the working of SQL Server. Let’s say, I want to update a few records of a table in […]

SQL Server 2016 – Trace Flag 1118 Changes

Hi Friends,

My today’s blog post is focused on trace flag 1118 changes in SQL Server 2016. Every DBA knows, this trace flag is generally used to allocate dedicated or uniform extent rather than mixed extents for databases to minimize the contention of mixed extent allocation. You can read the same in one of my […]

SQL Server 2016 – Trace Flag 1117 Changes

Hi Friends,

My today’s blog post is focused on trace flag 1117 changes in SQL Server 2016. We all know that there are multiple trace flags in SQL Server. These trace flags are generally used to change the default behavior of SQL Server. One of these trace flag is 1117. This trace flag is generally […]

Mixing OLTP and DW – A Tale of Seven Wonders – Wonder 6

Hello Geeks,

Welcome to the new series of seven wonders of SQL Server. These are not the wonders which make you say Aww. These are the ones which make you really wonder why. I will be covering the seven of such jaw dropping situations where you wonder what is happening and few bizarre reasons why […]

Heap versus Clustered Table

Hi Friends,

Today we are going to discuss on Heap versus Clustered Table. Many times we as a DBA have given the suggestions that avoid the use of Heap [Table without clustered index] in the database. There are lots of reasons for recommending the Clustered Table [Table with clustered index] rather than Heap. One of […]

Hidden Gems of SQL Server 2014 – Managed Lock Priority

Problem Statement:
Theoretically online index rebuild does not block. Practically boom… They do. Online index rebuild operations does not take down your indexes. But there is a point in the index rebuild where they build the new index structure and switch from your old index structure to new one. This is a simple metadata pointer […]

SQL Server Memory Nodes – How many do I have?

Hi Friends,

SQL Server Memory Nodes serve the foundation for SQL Server Memory and they have one-to-one mapping with physical NUMA nodes. For example, if your system has four physical NUMA nodes, your SQL instance will have four Memory Nodes. In case your system does not have NUMA, SQL instance will still have one Memory […]

Newsletter_Footer