How to do a Case-sensitive Search? I was asked this by one of my clients of Comprehensive Database Performance Health Check.
SQL SERVER – Top 3 Wait Stats from Real-World
It took me more than 9 hours to respond back every single email, I had received on this topic. Here are the Top 3 Wait Stats from Real-World.
Wait Stats for Performance – SQL in Sixty Seconds #157
I finally decided to create a video on that topic on my SQL in Sixty Seconds Channel. I will create more videos on the topic Wait Stats for Performance.
SQL SERVER – Find Untrusted Foreign Key
Today we are going to see the script in which we can find all the untrusted foreign keys in your database. My client asked this question.
SQL SERVER – Get Column Names
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.