During the recent Performance Check, I had a very interesting situation where my client wanted to capture the details of the sp_who2 in a table with DMVs.
Line Numbers for SSMS Efficiency – SQL in Sixty Seconds #147
This is when the line numbers in SSMS comes in extremely handy and let us learn in today’s blog post how we can do that. Let us learn today.
SQL SERVER – 5 Recent Underperforming Videos – Dec 2020
Today we are going to see the 5 recent underperforming videos. I often build short videos based on my real-world experience.
Slow Running Query – SQL in Sixty Seconds #146
One of the most popular questions I receive during Comprehensive Database Performance Health Check is if I have a script that lists Slow Running Query.
SQL SERVER – Stored Procedure Parameters and Single Quotes
Recently during SQL Health Check I had an interesting conversation with Sr. DBA about Stored Procedure Parameters and Single Quotes.
SQL SERVER – Convert Formatted Integer Values into Date
One of my clients of Comprehensive Database Performance Health Check asked me a question about how to Convert Formatted Integer Values into Date.
Change Database and Table Collation – SQL in Sixty Seconds #145
I discussed the method to change the database and table collation with my client during the Comprehensive Database Performance Health Check.
SQL SERVER – Long Running Queries with Execution Plan
I have a simple script that will list all the long running queries in the database with the execution plan. Well, the answer is yes.
SQL SERVER – sp_updatestats Performance and Disabled Nonclustered Indexes
Today I am going to share our very interesting conversation about sp_updatestats and Disabled Nonclustered Indexes. Let us discuss.
Build Your First Data Visualization with ChartBlocks – Pluralsight Course
FusionCharts is a very effective way to represent visualizations. I have to build a course – Build Your First Data Visualization with ChartBlocks.