Well, we discussed this during SQL YouTube Live – Performance Troubles – Execution Plans. Let us see MAX Column ID Used in Table.
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.
How to Find Instance Name for Availability Group Listener? I was recently asked this by DBA at Comprehensive Database Performance Health Check.
Let us see a very simple script today. It is about Altering Column – From NULL to NOT NULL. Comprehensive Database Performance Health Check