Well, we discussed this during SQL YouTube Live – Performance Troubles – Execution Plans. Let us see MAX Column ID Used in Table.
I got lots of feedback about my audio setup and the video configurations. I have planned another live session Performance Troubles – Execution Plans.
After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.
I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE.
It is not possible to use CASE Expression in Default Values when you add a new column. I hope this answers the question. However, there is a workaround.