What really is NUMA and why do we as database administrators care? NUMA stands for “Non-uniform Memory Access” and allows for increased CPU & memory performance. This is because a memory bank is physically adjacent to a CPU socket on the motherboard of the server. Each combination of memory and […]
Issues When Using Temporary Tables in Nested Stored Procedures
SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables. One of the capabilities is to allow for stored procedures to call other stored procedures. This is called “nesting” one stored procedure within the context of the calling stored procedure. In addition, you […]
Enabling SQL Server Optimizer Hotfixes
There are a number of knobs and switches that are available to database administrators that can be used to enable better performance. There are three options in particular that this blog will be discussing, trace flag 4199, the database scoped configuration QUERY_OPIMIZER_HOTFIXES and the qeury hint ENABLE_QUERY_OPTIMIZER_HOTFIXES. Understanding how these […]