A very common question, I keep on getting is how to get column names for a particular column. Well, it is pretty straightforward and easy to do.
SQL SERVER – Fix: There is already an object named ‘MyFirstTable’ in the database
Recently I had a very interesting scenario with a client when they faced an error about already object named that exist in the database.
SQL SERVER – Convert Date Time AT TIME ZONE
My client last week about Comprehensive Database Performance Health Check. The question was how to Convert Date Time AT TIME ZONE.
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
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.