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...
SQL Server Blog Posts
Microsoft SQL Server: Advantages and Best Practices for Technical Corporate Decision Makers
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...
Page Splits and How to Optimize Index Space in 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 is...
SQL Server 2022 Release – What Are We Excited About?
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...
Using Replication Monitor in Legacy (Pre-2016) SQL Server Management Studio
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...
What is NUMA: Why Does SQL Server Care?
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...
Best Practices for Deploying SQL Server Using vSphere
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...
Troubleshooting Transient AlwaysOn and Windows Failover Cluster Service Timeouts
You can also check out the Recorded Webinar. You may see events in your error logs reporting transient connection failures between cluster nodes or AlwayOn. You may observe high Asynch_Network_IO in [sys].[dm_os_wait_stats]. And you may have even brought it to the...
The Difference Between Blocking and Deadlocks
When I was learning about Microsoft SQL Server issues a DBA needs to understand, I was reading about deadlocks. At first, I was confused because it sounded like the definition of blocking, which I was already more familiar with. I re-read it a couple of times and...
Deadlocking – A Common But Frustrating Issue
Deadlocking is a common issue in SQL Server that can have a direct negative impact on your users. What is deadlocking and how can it be resolved? All relational database management systems provide some kind of locking by design. There are times you want a table to be...