What is the fastest way to retrieve rowcount for a table? Whenever I am helping my clients with their SQL Server, I get this question.
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.