Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

Can we do dml on views?

121

Can you index views?

123

Does view occupy space?

118

What is difference between materialized view and view?

129

How do you create a clustered index?

125

How do you drop an index?

123

How does clustered and non clustered index work?

117

What are the types of indexing?

125

What is an index in a database?

115

What is the need for indexing?

127

What are the lambda triggers?

116

Can you leave a union at any time?

122

Does union all remove duplicates?

132

What does it mean to be in union?

115

Why union all is faster than union?

128







Un-Answered Questions { SQL Server }

What is the use of RDBMS?

197


What is isolation levels?

182


How do I view views in sql server?

114


Can two tables have the same primary key?

119


How to optimize stored procedures in sql server?

199






How do you set a trace flag in sql server?

133


what are different types of raid configurations? : Sql server database administration

139


Do you know what are pages and extents? : SQL Server Architecture

167


Can we use pragma autonomous_transaction in trigger?

137


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1106


How to throw custom exception in Stored Procedure?

184


what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

147


How to create a view with data from multiple tables?

165


What are the advantages dts has over bcp?

149


What is database dimension? : sql server analysis services, ssas

197