1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 10106

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

HCL,

2 4163

wht's the differece between sqlserver05 and sqlserver2000

 3 4773

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

HCL, Virtusa,

7 12278

what is meant by deafult in sql server?

2 4740

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

Virtusa,

16 26343

any one can explain Self mapping Delegation Remote Credentials

 1 4607

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

 6 17647

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

Accenture,

2 6737

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

Accenture,

2 7016

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 10961

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

Accenture, Polaris,

2 9022

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?

 1620

how to delete duplicate rows from table

CSC,

9 11750

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

CSC,

2 9821

Un-Answered Questions { SQL Server }

How many categories of data types used by sql server?

584

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

590

What is SQL Azure Federations?

98

How will you find out if there are expensive SQL statements running or not?

572

What do you mean by subquery?

575




What is collation sensitivity? Explain different types.

537

What the different types of Replication and why are they used?

538

What is Lock table in SQL?

995

System variable and temporary variables

1700

How would we use distinct statement? What is its use?

596

What is the main purpose of having conversation group?

487

What new data source types were added in ssrs 2014?

105

How to use wildcard characters in like operations in ms sql server?

588

Can we check locks in database? If so, how can we do this lock check?

519

Explain datetimeoffset data type in sal server 2008?

525

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