Sp_Monitor : It is a useful system function used to see the statistics of the SQL Server. Following image shows the[…]
Read moreMonth: May 2011
SQL Server-Interview Questions
RDBMS: What is normalization and what are its pros and cons? What is demoralization and what are its pros and[…]
Read moreSQL 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
