SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

Why use “in” clause in sql server?

1071

Write an sql query to find the names of employees start with ‘a’?

1 1731

When would you use it?

987

What is the difference between ‘having’ clause and a ‘where’ clause?

1034

How to add code to the existing article (using improve article)?

1102

Explain about link server in sql server?

1050

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 2035

What is the difference between delete and truncate statements?

1067

Explain foreign key in sql server?

1019

What is a field in a table?

1035

What are a scheduled jobs or what is a scheduled tasks?

899

List the different types of joins?

978

What is the difference between char and varchar2 datatype in sql?

1062

What are entities and relationships?

969

What is the difference between dropping a database and taking a database offline?

1166

Un-Answered Questions { SQL Server }

What is ms sql server triggers?

1005

Explain some stored procedure creating best practices or guidelines?

927

What is an identity?

1005

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1123

What is Federation and Federation Member?

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1022

Define Business Edition in SQL Azure?

100

Explain what is the function of sql server agent windows service?

990

How to find index size for each index on table?

998

What is a schema in ms sql server 2005?

962

What is a ddl statement?

905

What is the importance of a recovery model?

1040

What is the xml datatype?

1049

How to find the list of fixed hard drive and free space on server?

1187

What is the chart in report?

158

For More Un-Answered { SQL Server } Questions Click Here