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 8332

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

HCL,

2 2746

wht's the differece between sqlserver05 and sqlserver2000

3 3204




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

HCL, Virtusa,

7 8911

what is meant by deafult in sql server?

2 3255

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

Virtusa,

16 19708

any one can explain Self mapping Delegation Remote Credentials

1 3569

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

6 14936




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

Accenture,

2 4525

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

Accenture,

2 4777

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 8205

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

Polaris, Accenture,

2 6814

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?

817

how to delete duplicate rows from table

CSC,

9 8202

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

CSC,

2 7812


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

How do you Implement SSIS Packages in your Project?

790


on line cluster can we make if yes tell me the procedure

794


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

848


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

266


How you trouble shoot when any job fails

629






what is package and it uses and how can u call a package

835


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

613


how can u get last observation in an unknown dataset ?

1083


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1458


wat wil hapn if we give the both read and deny read permission to user?

889


How to trouble shoot if unable to connect SQL Server

725


Delete duplicate rows without using rowid.

136


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1252


tell me the disaster recovery plan

1238


If the job running very slow what is the action you do

663