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?

236

What are sub reports?

208

How to create sub reports?

251

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

1022

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

1101

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

1010

which table keeps the locking information? : Sql server administration

1140

what is a mixed extent? : Sql server administration

1177

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

1039

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

1178

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

1107

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

1063

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

1078

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

1162

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

1098

Un-Answered Questions { SQL Server }

Explain about local stored procedure?

1031

What is it’s similarity with sql server?

160

How to convert a table data in XML format in sql server?

2597

Explain data warehousing in sql server?

1092

What does it mean to be in union?

986

What is the use of floor function in sql server?

1132

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1077

How to delete a database in ms sql server?

1325

What are diverse clauses that form a part of sql?

1115

What are the advantages of using third-party tools?

1041

What are indexes in sql?

1355

Explain the categories of stored procedure?

985

What is merge join?

1240

What is difference between cte and view?

979

Do you know what are acid properties of transaction?

1008

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