by Faryl O'Neil | Nov 21, 2022 | Blog, SQL Server
If you’re noticing a significant drop in performance, as well as frequent index fragmentation, you might have an issue with page splits, especially if your fill factor is set to default on all of your indexes. What Are Page Splits? Page splits occur when there...
by XTIVIA | Nov 16, 2022 | Blog, SQL Server
With the release of SQL Server 2022 for mainstream, we checked in with our DBAs to see what they are most excited about in the new version. We have all been waiting patiently for this release and are really happy to see it drop for mainstream support. Parameter...
by Faryl O'Neil | Nov 9, 2022 | Blog, SQL Server
Is SQL 2016 older than SQL 2005? Or is your outdated SQL Server Management Studio (SSMS) lying to you? Sometimes, the most interesting discoveries come from being lazy. Case in point: I was working with a few other DBAs on a client system having issues with...
by Ken Haff | Sep 13, 2022 | Blog, SQL Server
Multi-GHz processors need maximum memory bandwidth to reach their full potential.SQL Server needs maximum memory bandwidth to reach its full potential. They need to access memory as fast and with as much throughput as possible. A bottleneck develops when processors...
by Ken Haff | Sep 6, 2022 | Blog, SQL Server
A properly designed virtualized SQL Server instance running in a VM with Windows Server (or Linux), using vSphere is crucial to the successful implementation of enterprise applications. One main difference between designing for performance of critical databases and...
by Emily Seats | Aug 9, 2022
SQL Server Reporting Services (SSRS) On-premises tools and services that create, deploy, and manage mobile and paginated reports Talk with Our Experts R SSRS Architecture Review Review or audit the current architecture and provide recommendations in regard to...