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.
Infinite Loop – SQL in Sixty Seconds #144
Lots of people wrote feedback about it and wanted me to explain in this video so I have built this new Video where I discuss Infinite Loop.
SQL SERVER – Change Database and Table Collation
Recently I was helping my client with a health check and we walked into a very interesting scenario. We had to change the database collation.
SQL SERVER – Writing Infinite Loop
We had to write a loop that runs continuously at every one second and captures the details. Let us learn how we can write an infinite loop.Â
Efficiency Trick – Query Shortcut – SQL in Sixty Seconds #143
I have built a new SQL in Sixty Seconds video which describes how Query Shortcut works and how we can change them. Let us learn today.
SQL SERVER – Query Shortcuts
One of my clients who hired me for the Database Performance Health Check got very impressed that I was able to use efficiently query shortcuts.