During the recent consulting engagement, I ended up a very interesting situation where I had to drop all the auto created statistics.
Question: What are Different Methods to Know the Row Count of Table? The answer to this question is very simple and many.
How to Find Definition of Computed Column in SQL Server using T-SQL? – Interview Question of the Week #233
Question: How to Find Definition of Computed Column in SQL Server using T-SQL?
Answer: A very fair question, I received the other day.
Question: What is Source_Database_ID in Sys.Databases and why it is mostly NULL? Very interesting question, I received indeed.
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.