Interview Questions and Answers are now updated with SQL Server 2008 Questions and its answers.
Few days ago, I have received email from users asking question :How to run 64 bit SQL SERVER 2005 on 32 bit operating system?
We can use either CHARINDEX or PATINDEX to search in TEXT field in SQL SERVER. The CHARINDEX and PATINDEX functions return the starting position of a pattern you specify. Both functions take two arguments. With PATINDEX, you must include percent signs before and after the pattern, unless you are looking…Read More
Index Scan retrieves all the rows from the table. Index Seek retrieves selective rows from the table.