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 the diff between Dynamic queries and static queries

CGG, ICS Integrated Computer Solutions,

1 11018

Hi..here i would like to know the Backup and Restore models?

HCL,

2 5189

wht's the differece between sqlserver05 and sqlserver2000

3 5924

how to find number of columns in a table in sql server 2000 and 2005 also

HCL, Virtusa,

7 14582

what is meant by deafult in sql server?

2 5875

how to find number of columns in a table in sql server 2000 and 2005 also

Virtusa,

16 31130

any one can explain Self mapping Delegation Remote Credentials

1 5409

What is the difference between views and stored procedures? Can we have input parameters for views?

6 19716

Which databases are part of SQL server default installation? Explain the usage of each?

Accenture,

2 7904

What all db objects can be found in MSDB database of a SQL Server instance?

Accenture,

2 8246

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

Accenture,

3 12597

What is Query Execution Plan? How does it help optimize or tune a database driven application?

Accenture, Polaris,

2 10368

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2129

how to delete duplicate rows from table

CSC,

9 14357

What is the diff between Static Queries and Dynamic queries give me some examples

CSC,

2 10994

Un-Answered Questions { SQL Server }

How do I find the query plan in sql server?

1020

When you should use a low fill factor?

1044

What is bcp? When does it use?

994

How to copy the tables, schema and views from one sql server to another?

1112

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1037

List out a number of the wants to setup a SQL Server failover cluster?

1131

What is buffer cash and log cache in sql server?

1195

Explain about Normalization?

1124

What is the web service used for reporting services?

126

What are built in functions?

1073

What is hot add cpu in sql server 2008?

988

What are the instances when triggers are appropriate?

1022

What is database architecture? : SQL Server Architecture

1105

What are the aggregate and scalar functions?

1138

What are synonyms?

1019

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