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 10834

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

HCL,

2 4965

wht's the differece between sqlserver05 and sqlserver2000

3 5681

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

HCL, Virtusa,

7 14147

what is meant by deafult in sql server?

2 5634

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

Virtusa,

16 30064

any one can explain Self mapping Delegation Remote Credentials

1 5269

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

6 19301

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

Accenture,

2 7705

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

Accenture,

2 8025

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 12292

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

Accenture, Polaris,

2 10130

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?

2033

how to delete duplicate rows from table

CSC,

9 13802

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

CSC,

2 10746

Un-Answered Questions { SQL Server }

How to use “drop” keyword in sql server and give an example?

1097

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1099

In what sequence sql statement is processed?

962

What are the elements of dbms?

930

How to check table values in sql server?

921

What are the advantages of sql stored procedure?

1023

What is the difference between deallocate cursor and close cursor?

1183

Write a SQL command to insert and update only a particular field?

1054

What is page-level compression?

911

What is sqlcmd?

973

How do I find my localdb version?

946

Difference between group by clause and having clause in SQL?

933

what are the Prerequisites for Replication?

11255

How can we check the sql server version?

993

How to get a list of columns using the "sys.columns" view in ms sql server?

925

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