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

What is the difference between coalesce() & isnull()?

147

What is the difference between local and global temporary tables?

156

What is bcp? When does it use?

136

What is the osql utility?

146

Explain the steps needed to create a scheduled job?

136

What are the types of joins in sql?

149

What are orphan records?

155

What have included columns when we talk about sql server indexing?

146

List all the types of user-defined functions?

143

Why use “nolock” in sql server?

141

Explain primary key in sql server?

128

What is the filtered index?

146

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

136

How will you go about resolving deadlocks?

139

What is the difference between osql and query analyzer?

151







Un-Answered Questions { SQL Server }

What is the fillfactor concept in indexes?

142


How many tables can be joined in SQL Server?

171


How secure is sql server database?

119


Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

165


Do you know what are various aggregate functions that are available?

149






What is the purpose of linked server configuration in sql server?

138


What is the difference between count () and rowcount ()?

114


How do I clean up sql server transaction log?

133


We need to perform what steps in the following order to work with a cursor?

248


Tell me what is the significance of null value and why should we avoid permitting null values?

157


What are four major operators that can be used to combine conditions on a where clause?

182


What is the server name in sql server?

131


Explain about remote stored procedure?

146


What is de-normalization in sql database administration? Give examples?

169


What is enhanced database mirroring in sql server 2008?

145