so I get to see a lot of SQL Servers -- and a lot of SQL Server performance problems. No one calls us when everything is running well. One thing I have noticed in a number of recent consultations ...

Since SQL Server 2016 SP1, compression is built into ... You can read more about data compression here. Performance tuning your databases can dramatically improve the performance of your ...

Extended Events (XEvents): XEvents was introduced in SQL Server 2008 and then greatly matured over the next few releases. XEvents supersedes the Profiler toolkit and offers a wide and powerful array ...

OK, I’ll admit it. I’m not a DBA, but that doesn’t mean I haven’t overseen databases and their performance. I was (and probably still am) the guy who installed a Microsoft SQL database by hitting Next ...

When I worked for Sybase, much of the advertising we published was based on the TPC performance benchmark figures of Sybase SQL Server compared to the competition. The Transaction Processing ...

Intel's Hyperthreading Technology (HT) is being blamed for server performance problems. With both SQL Server and Citrix Terminal Server installations, HT-enabled motherboards show markedly ...

Targeting the current industry trend, SQL Server 2025 will allow developers to build AI applications using their data with improved security, performance, and availability. At Build 2025 ...

SQL Server Enterprise offers “partitioning ... When a developer needs to hand-write a query to get the best possible performance, they don’t know how. On the other hand, ORMs make writing ...

Whether they use SQL Server, Oracle, DB2 ... This takes a toll on performance and resources, some of which won’t manifest until you hit scale. Always examine queries you intend to repurpose ...