Author: parmsingla

SQL Server 2005-TSQL Parsing

Following are the Steps used by Query Optimizer to Process a TSQL:

Applies on : SQL Server 2005 and above Tested on : SQL Server 2005 1). Check Server Property: 1.1 Right[…]

Sp_Monitor : It is a useful system function used to see the statistics of the SQL Server. Following image shows the[…]

RDBMS: What is normalization and what are its pros and cons? What is demoralization and what are its pros and[…]

Question: Why Index Scan is happening even thought index exists on predicate column? Ans: Generally,Query Optimizer (QO) tries to use[…]