SQL Server Interview Questions
Questions Answers Views Company eMail

What is the diff between Dynamic queries and static queries

ICS Integrated Computer Solutions, CGG,

1 8409

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

HCL,

2 2779

wht's the differece between sqlserver05 and sqlserver2000

3 3247




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

HCL, Virtusa,

7 8976

what is meant by deafult in sql server?

2 3289

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

Virtusa,

16 19812

any one can explain Self mapping Delegation Remote Credentials

1 3601

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

6 15004




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

Accenture,

2 4608

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

Accenture,

2 4842

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 8283

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

Polaris, Accenture,

2 6896

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?

835

how to delete duplicate rows from table

CSC,

9 8271

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

CSC,

2 7890


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

what are the critical issues you have resloved in your company

790


query processing

975


which backup strategy you are following at ur company

963


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1237


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

1370






Tell about MOM Tool(Microsoft Operator Manager)?

653


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

831


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2610


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1124


How you trouble shoot when any job fails

653


How to trouble shoot if unable to connect SQL Server

744


If we delete pack Spec what will be the status of pack Body ?

147


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2649


How to restore performance issues and how to check?

813


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

854