| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to get the count of distinct records. Please give me the
query? | Value-Labs | 5 |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 6 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 9 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| how many type of subquery? | | 2 |
| What are the types of indexes available with SQL Server? | | 2 |
| What is mean by "fill factor" ? and what is mean
by "Index "in sql? | Logica-CMG | 1 |
| what are default? Is there a column to which a default cant be
bound? | | 1 |
| How can you get @@error and @@rowcount at the same time? | | 5 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 11 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| What is the role that is required for killing a process
What is the role that is required for creating a linked
server
| IBM | 1 |
| How can you see what type of locks used? | | 1 |
| How m-m relationships are implemented? | | 1 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| What is a table called, if it does not have neither Cluster
nor Non-cluster Index? | | 1 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| how can we use a composite key for two tables and how can
we represent it | BoA | 1 |
| |
| For more SQL Server Interview Questions Click Here |