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 are cascading parameters in ssrs reports?

231

What are sub reports?

204

How to create sub reports?

245

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

974

what is the primary use of the model database? : Sql server administration

1054

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

959

which table keeps the locking information? : Sql server administration

1107

what is a mixed extent? : Sql server administration

1110

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

990

where can you add custom error messages to sql server? : Sql server administration

1127

how you can get the list of largest tables in a database? : Sql server administration

1058

can a database be shrunk with users active? : Sql server administration

1016

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1037

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1088

How you can get a list of all the table constraints in a database? : Sql server administration

1030

Un-Answered Questions { SQL Server }

Which are the olap features?

963

how many bits ip address consist of? : Sql server database administration

904

What is partition in sql server?

1042

What are basics of policy management?

1107

Tell me what is normalization? Explain different forms of normalization?

1033

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1112

What are user-defined functions (udfs) in sql server?

995

Explain time data type in sal server 2008?

930

How will you monitor replication latency in transactional replication? : sql server replication

1152

What is inner join? Explain with an example?

1229

What is dirty page?

978

Do you know what guidelines should be followed to help minimize deadlocks?

973

How to insert multiple rows with one insert statement in ms sql server?

1131

What is dynamic cursor in SQL SERVER?

1084

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1026

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