One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’.
Choosing a Processor for SQL Server
Choosing a Processor for SQL Server is always a challenge and I often find DBAs and organizations struggling with the same.
SQL SERVER – Drop All Auto Created Statistics
During the recent consulting engagement, I ended up a very interesting situation where I had to drop all the auto created statistics.
SQL SERVER – Details About SQL Jobs and Job Schedules
SQL Expert Dominic Wirth has written a very interesting script about SQL Jobs and Job Schedules. Let us learn about that in this blog post.
SQL SERVER – Query to List All Jobs with Owners
During the engagement suddenly a Jr. DBA asked me if I have a query that will list all the jobs in their system with the Job’s owner.
SQL SERVER – Display Rupee Symbol in SSMS
Just instead of US Dollar Sign ($), they wanted to display it with Indian Rupee Sign (₹). Let us learn today how we can Display Rupee Symbol in SSMS.
SQL SERVER – Script to Find All Columns with a Specific Name in Database
Recently, one of the clients asked me if I have a Script to Find All Columns with a Specific Name in Database. Yes, of course, I do have it.