How do you choose columns to create indexes in a table?
Posted in SQL Interview Questions by Chandrasekhar Raparthi On June 3, 2014
We should create indexes on the columns which are, Mostly used in WHERE clause Mostly used in JOIN conditions Mostly used in Order by If we are creating a concatenated index on more than one column, give first preference to the column
Assignment Operator
Posted in SQL Tutorials by Chandrasekhar Raparthi On June 1, 2014
The name itself is saying that, it assigns values to the variables or fields of a table. We have only one assignment operator ‘=’ in SQL Server. It plays a key role while writing queries. We cannot write complex queries without Assignment