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

How to rebuild indexes with alter index ... Rebuild?

1179

What samples and sample databases are provided by microsoft?

1087

What happens if strings are casted into wrong code pages in ms sql server?

1162

How to disable a login name in ms sql server?

1172

What are the character string functions supported by sql server 2005?

1072

How to connect sql server management studio express to sql server 2005 express?

1102

What happens if you delete a table that is used by a view?

1059

What happens if you are trying to access a schema not owned by you?

1020

How to move database physical files in ms sql server?

1093

How to get a list of columns in a view using the "sp_help" stored procedure?

1087

How to drop an existing table with "drop table" statements in ms sql server?

1144

How to create a simple user defined function in ms sql server?

1068

How to create new tables with "create table" statements in ms sql server?

1105

How can windows applications connect to sql servers via odbc?

1174

How to drop an existing schema in ms sql server?

1141

Un-Answered Questions { SQL Server }

Can we linked SharePoint to a SQL database?

1073

explain different types of backups avaialabe in sql server? : Sql server database administration

1032

What is a trace frag? Where do we use it?

1149

tell me the disaster recovery plan

2558

What do you understand by integration services in sql server?

998

What are commonly used odbc functions in php?

1056

What is an example of a foreign key?

1029

What is a virtual table in sql?

1035

Which are the new data types introduced in sql server 2008?

927

Explain triggers?

1061

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1039

How can I get data from a database on another server?

1043

What the difference between UNION and UNIONALL?

1086

Explain the working of sql privileges?

1143

What are the differences between left join and inner join in sql server?

1149

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