Things SQL Server vNext Should Address: Add Lock Pages In Memory To Setup Options

This setting doesn’t get enough credit for all the good it does. Part of me thinks it should be the default for new SQL Server installs, if the amount of…

Read the post: Things SQL Server vNext Should Address: Add Lock Pages In Memory To Setup Options

Things SQL Server vNext Should Address: Make Dynamic SQL Easily Traceable

One tricky thing about working with dynamic SQL is that it’s rather unaccountable. You have a stored procedure, you build up a string, you execute it, and…

Read the post: Things SQL Server vNext Should Address: Make Dynamic SQL Easily Traceable

Local Variables Get Bad Cardinality Estimates In Cursors In SQL Server, Too

While helping a client out with weird performance issues, we isolated part of the code that was producing a whole bunch of bad plans.

Read the post: Local Variables Get Bad Cardinality Estimates In Cursors In SQL Server, Too