Need the Windows version SQL Server runs on? Get OS information with the sys.dm_os_windows_info DMV, or read it from the ERRORLOG at startup.
How to Enable Auto Update Statistics and Auto Create Statistics with T-SQL – Interview Question of the Week #108
Question: How to Enable Auto Update Statistics and Auto Create Statistics? Let us learn how we can fix that in today’s blog post.
SQL SERVER – Database Mirroring Connection Error 4 – An Error Occurred While Receiving Data: 10054
Setting up mirroring on fresh Azure VMs, I hit database mirroring connection error 4. It looked like a connectivity problem, but it was something else.
SQL SERVER – Script to Find and Monitoring TempDB Space Usage
A client’s TempDB log grew to 80 GB while the data file was 5 GB. Here is the script I used for monitoring TempDB Space usage and finding the cause.
SQL SERVER – Error Msg 10778, Level 16 with InMemory OLTP
Can an InMemory table have a foreign key to a disk-based table? I tried it and got Msg 10778. Here is what the error means and the limits to know.
SQL SERVER – Understanding JSON NULL Value Using STRICT Keyword
Why does a JSON path that doesn’t match return NULL? Add the STRICT keyword to get an error instead. A follow-up on JSON NULL values in SQL Server 2016.
Find All Queries with Implicit Conversion in SQL Server – Interview Question of the Week #107
Question: How do I find out how many queries have an Implicit Conversion in SQL Server? The source of this question is very interesting.