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.