Investigate linked server performance and failures by checking remote work, provider settings, security mappings, and the alternatives available.
SQL SERVER – Performance Analysis of Backup to Azure
Compression saves backup space, but does it save time too? My Performance Analysis of backup to Azure compares timings with and without compression.
Columnstore Segment Elimination: Loading Data So Scans Skip Work
See how segment elimination skips columnstore work by checking segment metadata, measuring scans, and loading rows in a useful order.
Network Packet Size: When a Bigger Packet Helps Large Results
Test network packet size on a specific SQL Server connection, verify the negotiated value, and compare large-result performance carefully.
SQL SERVER 2016 – Creating Clustered ColumnStore with InMemory OLTP Tables
While preparing my SQLPASS session on SQL Server 2016, I explored creating clustered ColumnStore with InMemory OLTP tables. Here is what I learned.
SQL SERVER – Set AUTO_CLOSE Database Option to OFF for Better Performance
How I helped a customer get better performance by setting the AUTO_CLOSE Database Option to OFF, and why this setting hurts busy databases.
SQL SERVER – How to Hide Number of Rows Affected Message? – SET NOCOUNT
In this blog post, we are going to talk about how to hide the number of rows affected messages with the help of SET NOCOUNT.