In Part 1 of this series, we looked at a brief description of in-memory tables, the syntax for creation, and benchmarked data insertion and update. Part 2 will continue with a concentration on the SELECT statement for benchmarking, and also touch on in-memory stored procedures. In-Memory SELECT Performance For the purpose of the following […]
Read More
I’ve always been fascinated by performance, and my careers and hobbies have shown this. I’ve been a rocket scientist, sports car driver, USAF fighter pilot, and now a SQL Server® geek. When in-memory tables first came out in SQL Server 2014, I was highly intrigued by the prospect of something that did not require the […]
Read More
Read Part 1 Read Part 2 This was originally intended to be a two-part blog, but I keep finding other areas to explore. Shortly after completing Part 2, I realized that perhaps I should traverse a row compressed index to see how the SQL Server® structures it. Then, the other night, I gave a presentation to our […]
Read More
/************************************************************************************ This script explores row compressed non-clustered indexes and the use case when the Primary Key and Clustered Index are not the same (with options) at the page level. Most likely, the page ids used here will change in your database configuration and setup—mine rarely used same page ids even with repetitive usage. However, the […]
Read More
The title describes what I started up to do, but as usual, I like to experiment with queries to see if I can beat the optimizer for an acceptable query plan. Initially I thought the OR clause described below would be the best solution, but with a little experimentation, I found the order of columns […]
Read More
Read Part 1 Read Part 3 This is a continuation of Climbing the SQL Server Index B-tree. In Part 1, we dove down into the SQL Server® pages for a Clustered Index in the Sales.SalesOrderDetail table in the AdventrueWorks2012 database. In this paper, we will look at the data pages of the same table/database for unique-nonclustered […]
Read More
Read Part 2 Read Part 3 The term “geek” applies to me because I am always wondering/tinkering with things that I don’t readily understand. Recently, I’ve become intrigued with “what’s under the covers” with SQL Server Indexes. Part 1 of this paper will dive down and look at the important items on each data page […]
Read More
–Brought to you as a script! Enjoy –� 2017 | ByrdNest Consulting –Index B-Tree Analysis /************************************************************************************ This script explores clustered, unique-nonclustered, and nonclustered indexes at the page level. Most likely the page ids used here will change in your database configuration and setup — mine rarely used same page ids even with repetitive usage. However, […]
Read More
Over last 18 months, I’ve given several SQL Saturday (and a PASS Virtual DBA) presentations on indexes. These presentations have evolved and I find it hard to complete the material I want to address in 60 minutes. But the more I dive into the material, the more I am learning. Several times I have been […]
Read More
Abstract SolarWinds® Database Performance Analyzer (DPA) is a performance analysis product unlike other resource-focused health and alerting monitors; it allows a comprehensive determination of why a particular TSQL statement or stored procedure is slow or creating a performance issue. DPA achieves its performance analysis using wait-based analytics vs. resource utilization/consumption approach. By using this technology, […]
Read More
Learn about SQL Server Change Tracking and some code to implement a data warehouse from creation to actual change tracking ETL.
Read More
Learn how to make SQL Server Change Tracking (CT) and the ETL process work efficiently in a data warehouse environment.
Read More