It is not possible to Propagation of Compatibility Level in AlwaysOn or mirroring from primary to secondary mirroring. Let us learn it today.
SQL SERVER – STRING_ESCAPE() for JSON – String Escape
Well, in situations like this we should consider using the function STRING_ESCAPE() which works for JSON. Let us quickly discuss String Escape.
Forwarded Records and Performance – SQL in Sixty Seconds #155
Forwarded records make SQL Server read extra pages when it scans a heap. In this SQL in Sixty Seconds video, I explain forwarded records and performance.
SQL SERVER – List Tables with Size and Row Counts
Is a huge table about row count or size? Here is a very simple script that lists tables with size and row counts in SQL Server.
MySQL MariaDB – Query Using Temp Table
SQL Server Performance Tuning but this time the question was more related to the MySQL installation they had in their system. Query Using Temp Table.
SQL SERVER – Check Backup Reliability
Recently I was asked by one of my clients of Comprehensive Database Performance Health Check recently asked if there is any way to Check Backup Reliability.
SQL SERVER – Finding Fragmentation in Forwarded Records
Start finding fragmentation in heaps by measuring forwarded records, then choose a heap rebuild or clustered index and verify the result.