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

Is it ok to shrink transaction log?

990

How do you rename a table in sql server?

1015

What is recompile sql server?

1031

What is tempdb in sql server?

970

What is query optimizer in sql server?

1014

What is the default sql server instance name?

1028

What is the maximum size of a row in sql server?

963

How do you clear a log file?

1040

What is the size of transaction log file?

924

What is the maximum rows in sql server table?

908

What is sleeping status in sql server?

1020

How do I find the sql server instance name?

961

What protocol does sql server use?

936

Is sql server difficult to learn?

914

What is log ldf?

974

Un-Answered Questions { SQL Server }

Define Wed Edition in SQL Azure?

100

How can i Relate Tables in SSIS

1076

How to delete exactly duplicate records from a table?

1058

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1072

What are triggers in ms sql server?

1157

How do I connect to sql server database?

1006

What are the differences between ms sql server & oracle?

1053

Do you think BCNF is better than 2NF & 3NF? Why?

1273

What are system databases into sql server (2005/2008) : sql server database administration

1003

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1012

Does sql server 2000 full-text search support clustering?

858

What is the impact on other user sessions when creating indexes?

918

How many types of cursor type are there?

1083

What is nonclustered index with included columns ?

961

Can we add a cpu to sql server?

1003

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