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?

1118

What samples and sample databases are provided by microsoft?

1031

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

1109

How to disable a login name in ms sql server?

1129

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

1006

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

1032

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

979

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

966

How to move database physical files in ms sql server?

1024

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

1030

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

1084

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

1012

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

1059

How can windows applications connect to sql servers via odbc?

1116

How to drop an existing schema in ms sql server?

1092

Un-Answered Questions { SQL Server }

If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

1099

which backup strategy you are following at ur company

2143

How do I save a stored procedure in sql server?

994

What is sql server profiler trace data file?

1106

How you can get the list of largest tables in a database?

1006

What is 2nf normalization form?

1130

What is the difference between varchar and varchar(max) datatypes?

1063

Can you explain full-text query in sql server?

1008

What is log shipping?

954

What are the different types of sql server replication? : sql server replication

1258

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1002

What do you mean by sql server 2005 express management tools?

1295

Can you get second highest salary from the table?

958

What is the significance of null value and why should we avoid permitting null values?

980

How to generate create view script on an existing view?

983

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