The varied responses led me to write a detailed blog post to clarify the correct answer. If you missed it, you can read it here. Let us see A Summary and Further Reading.
SQL SERVER – Scripts to Retrieve Column Names
Understanding how to retrieve column names from a table is one of the fundamental operations you should be familiar with.
SQL SERVER – Computed Column and Compute Scalar Operators
One of my clients recently asked me a very interesting question about the computed column and Compute Scalar Operators. Let us learn about it today.
SQL SERVER – Having Two Identity Columns for A Single Table
In yesterday’s session, a DBA asked an interesting question that if it is possible to have two identity columns for a single table. Yes and No.Â
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.
SQL SERVER – Columnstore Index Cannot be Created When Computed Columns Exist
Explorations working with SQL Server never stop and I get an opportunity to learn something every other day. Today I thought of bringing pout some learning that happened to me by accident. As I was not sure and assumed certain things, these came as a surprise learning for me. So let us see what is the issue at hand, which is about Columnstore Index and Computed Column.
SQL SERVER – Computed Column and Conditions with Case Statement
When I do not find anything on my blog, I write a blog post about it, so next time I do not have to recreate the scripts from the beginning. Just another day, I was doing performance tuning for an organization, I had to create a computed column with CASE statement and I suddenly realize that I do not have such a script on my blog so I decided to write a blog post on this subject.