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
Earlier I wrote a blog post on Forwarded Records and Performance and lots of people liked the blog post. Here is you can read the blog post SQL SERVER – What is Forwarded Records and How to Fix Them?
SQL SERVER – List Tables with Size and Row Counts
Today we will see a very simple script that lists table names with the size of the table and along with that row counts. Let us learn it in today.
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
I was asked by my client if there any way to know if there is any way of Finding Fragmentation in Forwarded Records. Let us learn in today’s blog post.
SQL SERVER – Who Dropped Table? Part 2
There is a way to find out few more things. However, before we continue I strongly suggest that you watch the following video about the dropped table.
Practical Real World SQL Server Performance for Everyone – 2021 Edition
This is a one-time opportunity to sign up for Practical Real World SQL Server Performance for Everyone. Feb 24-25 from 13:30-17:00 CET