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?

1127

What samples and sample databases are provided by microsoft?

1037

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

1113

How to disable a login name in ms sql server?

1134

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

1014

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

1042

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

990

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

968

How to move database physical files in ms sql server?

1033

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

1033

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

1086

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

1022

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

1066

How can windows applications connect to sql servers via odbc?

1128

How to drop an existing schema in ms sql server?

1103

Un-Answered Questions { SQL Server }

What are built in functions?

1022

What are page splits?

995

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

952

List out different types of normalizations in sql server and explain each of them?

929

What is indexing in sql server with example?

1004

what are the new features introduced in sql server 2000? : Sql server database administration

920

How to connect a database with sql express.?

1064

What does null mean?

988

What should be the fill factor for indexes created on tables? : sql server database administration

1138

How to add more data to the testing table in ms sql server?

1090

Call by value and call by reference in procedure and function, with NOCOPY.

1306

How many replicas are maintained for each sql azure db?

124

Describe triggers features and limitations?

989

How to truncate the log in sql server 2012? : sql server database administration

1289

What do we have to check in database testing?

1019

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