If any of your databases use in-memory tables, you’ve likely seen messages in your error log similar to this: Database ID: . Deleting unrecoverable checkpoint table row (id: 40568). You probab...
http://shaunjstuart.com/archive/2019/11/in-memory-tables-cause-tons-of-benign-entries-in-error-log/
I ran into an interesting case today. We’ve got a pair of SQL Servers running in an Availability Group. We’re set up so we can run with either server as the primary. We use Sentry One to moni...
I was doing some investigating the other day and trying to find which tables in our environment were the most written to. This was because my buddies in the IT department had gotten a bunch of ne...
Have you ever had random inserts into a large table fail? Most of the time, inserts happen fine, but every so often you get a failure with a “primary key violation” error? If your primary key...
http://shaunjstuart.com/archive/2018/08/finding-all-gaps-in-an-identity-column/
My company recently purchased SQL Sentry (oops, they changed the name to Sentry One over two years ago, although the website still says SQL Sentry all over the place) and I’ve been spending the...
http://shaunjstuart.com/archive/2018/05/error-8623-and-entity-framework/
I have just published my online courses at Skillshare.com. My courses were previously only available at Udemy.com. At Udemy, courses are sold on a per-course basis. At Skillshare, you sign up for...
http://shaunjstuart.com/archive/2017/09/online-courses-now-available-at-skillshare-com/
I ran into a problem with Availability Group backups the other day that had me scratching my head for a couple of hours before I finally discovered what was going on. When you set up an Availabil...
The 16.5.2 release of SQL Server Management Studio (which reports as 13.0.16105.4 in the About screen) has a bug where you cannot display a list of tables in databases that contain sparse columns...
It’s a SQL Server best practice to have Auto Create Statistics enabled on your databases. When this is on, SQL Server will create statistics on single columns when it needs them. However if som...
http://shaunjstuart.com/archive/2016/08/removing-duplicate-statistics/
I’ve been spending some time lately working with statistics, specifically auto-created statistics. When auto-create statistics is enabled, SQL Server will create column statistics when it needs...
http://shaunjstuart.com/archive/2016/08/the-case-of-the-multi-column-auto-created-statistic/