RDBMS: What is normalization and what are its pros and cons? What is demoralization and what are its pros and[…]
Read moreCategory: SQL Server
SQL Server – Cause Of Index Scan
Question: Why Index Scan is happening even thought index exists on predicate column? Ans: Generally,Query Optimizer (QO) tries to use[…]
Read more
