Category Archives: Interview Questions

Interview Questions, Sql Server Tutorials

Sql Server Interview question: What is a covered index?

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? →

Interview Questions, Sql Server 2005, Sql Server 2008, Sql Server 2012, Sql Server 2014, Sql Server Tutorials

Sql Server Interview question: Data deletion / Size reduction

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 →

C# Tutorials, Interview Questions, Sql Server 2005, Sql Server 2008, Sql Server 2012, Sql Server 2014, Sql Server Tutorials

Sql Interview Question: What is SQL CLR?

SQL CLR (SQL Common Language Runtime) is a technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment.

Continue reading Sql Interview Question: What is SQL CLR? →

Interview Questions, Sql Server Tutorials

How do you check if automatic statistic update is enabled for a database?

The following query can be used to determine if Automatic Statistic update is enabled: Continue reading How do you check if automatic statistic update is enabled for a database? →

Data warehouse, Interview Questions, SQL Azure, Sql Server 2005, Sql Server 2008, Sql Server 2012, Sql Server 2014, Sql Server Tutorials

Sql Interview question: What are the limitations of indexed views?

Some of the limitations with Indexed views are:

  • The UNION operation is not allowed in an indexed view.
  • We cannot create an Index on a nested view scenario which means we cannot create index on a view built from another view.

Continue reading Sql Interview question: What are the limitations of indexed views? →