Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



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 9332

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

HCL,

2 3453

wht's the differece between sqlserver05 and sqlserver2000

3 4026

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

HCL, Virtusa,

7 10318

what is meant by deafult in sql server?

2 3938

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

Virtusa,

16 22580

any one can explain Self mapping Delegation Remote Credentials

1 4159

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

6 16236

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

Accenture,

2 5633

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

Accenture,

2 5850

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 9475

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

Accenture, Polaris,

2 7971

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?

1275

how to delete duplicate rows from table

CSC,

9 10015

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

CSC,

2 8967







Un-Answered Questions { SQL Server }

Explain candidate key, alternate key, and composite key?

199


List all the types of user-defined functions?

200


What xml support does the sql server extend?

189


What is difference between inner join and full join?

163


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

172






What is a join in sql?

206


How do I start sql server agent automatically?

183


What is format parameter in ssrs?

48


How to create a user name in a database?

215


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

233


What is a database table?

187


When is update_statistics command used?

208


What is acid properties?

229


How you trouble shoot when any job fails

1084


how to create “alternate row colour”?

43