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.