My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I argue moving data into a #temp table is usually the wrong reflex, and invite you to make your case.

Index maintenance has always meant nightly jobs and a window you have to defend. Azure SQL’s new Automatic Index Compaction targets page density directly — so I tested it.

Compression was introduced in SQL Server version 2008. While it helped, the compression ratios were frequently too low to justify the...

When managing large databases or high-transactional databases, the performance of your underlying storage system is crucial, whether it...

Recently, one of my clients was experiencing performance issues with their SQL Server. Although the server was not underpowered from a...

Working with large databases, multi-terabyte in size, I've had clients who have wanted to move to the cloud. However, after testing and...

Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...

After several discussions with the Microsoft team and chatting with Sunil Sabat about the testing I was conducting, the conclusion was...

Sorry to disappoint you. In this post, we won't test Microsoft Fabric directly. We will compare Azure Data Factory (ADF) to Microsoft...

To quickly summarize where we are, we started testing Microsoft Fabric with a 10GB tar file, which took over 20 hours to extract, and now...

Shortly after Microsoft Fabric came out a few months ago, I created an account and started playing around. I love to push technology to...

How many of us have created a new table and used the default and first data type nvarchar for all of the text/alphanumeric fields, or had...

Recently a question came up on the various file types that would be best to load into PowerBI, so I ran a few tests to see how it would...

Recently I encountered a Microsoft SQL Server with relatively high and very consistent CPU usage with few peaks and valleys. When...

Over my years consulting, I've done quite a few performance tests for clients using DiskSpd (formally SQLIO), and I usually manually...

For VLDBs I've always created multiple files for each file group and had to set the trace flag 1117 on to ensure that all files grow at...

How many of us have just created a new table and put a Created Datetime and Modified Datetime field in with the default DateTime...