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?

1181

What samples and sample databases are provided by microsoft?

1089

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

1165

How to disable a login name in ms sql server?

1176

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

1074

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?

1061

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?

1097

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

1088

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

1147

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?

1108

How can windows applications connect to sql servers via odbc?

1177

How to drop an existing schema in ms sql server?

1144

Un-Answered Questions { SQL Server }

What stored procedure would you use to view lock information?

1016

What options are available to audit login activity? : sql server security

1199

How to use order by with union operators in ms sql server?

1065

What is auditing in sql server?

964

What is rank function?

1084

What is snapshot parameter in ssrs?

155

What are the Advantages of using CTE in sql server?

1166

What are the steps you will take to improve the performance of a poor performing query?

1019

how you can configure a running aggregate in SSRS?

199

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

1218

What is the full meaning of dml?

998

Difference between drill down and drill through report.

1003

What is mscorsvw.exe - process - microsoft .net framework ngen?

1003

Where are stored procedures in sql server?

1124

What do you know about system database? : SQL Server Architecture

1036

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