Language Integrated Query (LINQ) adds the ability to query objects using .NET languages. The LINQ to SQL object/relational mapping (O/RM) framework provides the following basic features: Continue reading .Net Interview question: What is LINQ?
The XML datatype holds and understands valid XML streams pretty much the same way that integers hold numbers with no decimal points, varchars hold strings of varying length, and the Geography datatype holds a position on the earth. Continue reading Sql Server Interview questions: What is the XML datatype?
In order to find all the tables without indexes just run the following query in the Query Editor:
Question : What is a covered index?
A covered index can satisfy a query just by its index keys without having the need to touch any data pages. When an Index covers the query in this way it is a called covering index. Continue reading Sql Server Interview question: What is a covered index?
Question: When you delete data from a table, is SQL Server reducing immediately the size of that table? Continue reading Sql Server Interview question: Data deletion / Size reduction