by Ken Haff | May 30, 2023 | Blog, SQL Server
What Are Natively Compiled Stored Procedures? These procedures are a new feature introduced in SQL Server 2014 that allows for faster and more efficient execution of queries and business logic that access memory-optimized tables. Memory-optimized tables are tables...
by XTIVIA | Mar 28, 2023 | Blog, SQL Server
As a technical corporate decision-maker, choosing the right database management system (DBMS) for your organization is crucial to ensuring efficient and effective data management. Microsoft SQL Server is one of the most popular DBMS options on the market today and for...
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...