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

what is normalization? : Sql server database administration

1041

what is a traditional network library for sql servers? : Sql server database administration

904

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1086

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

979

what is a transaction and what are acid properties? : Sql server database administration

977

what's the information that can be stored inside a bit column? : Sql server database administration

983

what is an extended stored procedure? : Sql server database administration

1009

what is the different types of backups available in sql server? : Sql server database administration

894

when would you go for denormalization? : Sql server database administration

828

what are defaults? : Sql server database administration

1034

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

937

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1012

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

934

what is sql server? : Sql server database administration

949

what is denormalization? : Sql server database administration

892

Un-Answered Questions { SQL Server }

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

1005

What is a field in a table?

997

What do you understand by mirroring and mention the advantages of the mirroring?

1023

What is inline table-value user-defined function?

1044

What is GUID in sql server?

1113

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2184

Explain what are various ways to enhance the ssrs report?

1009

What are different types of data sources?

957

What is shrink log file?

859

How can you insert values in multiple rows using one Insert statement?

1054

What is sub-query in sql server? Explain its properties.

1051

What are the different types of indexes?

1059

How to remove duplicate rows from table except one?

958

How is sql used in sql server?

966

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1063

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