Brian's datacorner

Filter articles by:
  • Datacorner
  • Fabric
  • Kusto adx
  • Power bi
  • SQL server
  • Synapse
  • Warehouse

    • // Week 4: Data Page Restrictions

    SQL Server t-sql 5 min.

    featured image Week 4: Data Page Restrictions You have just a few pages ahead of you, and then you have already passed the 1st month of the SQL Server Performance Tuning series - congratulations! Today I’m talking about limitations that you have with data pages, and why there are restrictions that you will love, while you will hate other restrictions. As you have learned in week 2, a data page is always 8kb large, and you are able to store 8060 bytes of data on it. [...]

    // Week 3: Extent Management in SQL Server

    SQL Server t-sql 3 min.

    featured image Week 3: Extent Management in SQL Server Wow, it’s already the 3rd week in the SQLpassion Performance Tuning Training Plan! In the mean time you already have a very good understanding about how SQL Server works internally. Today I’m talking about Extent Management in SQL Server, because this is a very important topic, when we cover TempDb in week 23. On a very high level an extent is just a group of 8 pages of 8kb. An extent is therefore always a chunk of 64kb. [...]

    // Week 2: Data Pages - the Foundation of SQL Server

    SQL Server t-sql 4 min.

    featured image Week 2: Data Pages - the Foundation of SQL Server Last week we have laid out the foundation about how SQL Server executes queries. I have also already talked here a little bit about pages that are buffers of 8kb. Today we are further concentrating on these pages and drill into more details and what it means from a performance tuning perspective. Pages are the foundation of SQL Server, everything in SQL Server is about pages. When we want to improve the performance of our queries, we try to lower down the page reads SQL Server needs for a specific query. [...]

    // Week 1: How SQL Server Executes a Query

    SQL Server t-sql 4 min.

    featured image Week 1: How SQL Server Executes a Query Hello, and welcome to the first issue of the SQL Server Performance Tuning series. Before we go into the nasty details of performance tuning in SQL Server, I want to lay out today the foundation about how SQL Server executes a query. This is a very important part, because in the upcoming issues of the series we will further enhance our knowledge based these concepts. The following pictures gives you an overview about the most important components within SQL Server, that are used when we are executing a query. [...]