Learn how to fix: Cannot insert a duplicate key row in object ‘sys.sysschobjs’ with unique index ‘clst’ while using DBCC CLONEDATABASE.
SQL SERVER – The Older Way to Find Size of Index Using Deprecated sysindexes
Earlier this month, I wrote a blog post about How to Find Size of the Index for Tables? – Interview Question of the Week #198, in this I had explained the way to find the size of the index for the table. However, while I was writing the blog post, I was thinking about how I used to love sysindexes once upon a time. However, as now I focus on the new DMVs, I decided not to provide the script of the sysindexes.
SQL SERVER – Missing Columns and Other Folders in SQL Server Management Studio (SSMS) in Object Explorer
On Random basis, I do get some emails and comments on my blog which makes me do some research and write more blogs to share my thoughts and findings. This blog is an outcome of one such email communication with a user. Let us learn about missing columns in SSMS.