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.
SET NOCOUNT ON in SQL Server: How to Hide Rows Affected Messages
SET NOCOUNT ON stops SQL Server from sending a rows affected message after every statement. This post tests what it changes and what it doesn’t: @@ROWCOUNT, scope inside a procedure, timing and the text that sp_updatestats prints. It also covers client programs that depend on the count.





