Sqlserver Interview questions


Total available count: 45
Subject - Databases
Subsubject - Sqlserver

How can a programmer enforce to use particular Index?

Yes, this is possible by using a Index hint (Index=<Index_name>) after the table name.

SELECT empname from employee(index=empid)

 

 

 




Next 5 interview question(s)

1
Explain the joins in SQL Server?
2
What is Index Tuning in SQL Server?
3
What are the differences between UNION and JOINS in SQL Server?
4
Explain the difference between text and image data type?
5
What are the data types in SQL Server?