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 8613

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

HCL,

2 2912

wht's the differece between sqlserver05 and sqlserver2000

3 3418




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

HCL, Virtusa,

7 9167

what is meant by deafult in sql server?

2 3434

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

Virtusa,

16 20240

any one can explain Self mapping Delegation Remote Credentials

1 3734

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

6 15226




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

Accenture,

2 4827

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

Accenture,

2 5023

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 8491

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

Accenture, Polaris,

2 7140

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?

930

how to delete duplicate rows from table

CSC,

9 8577

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

CSC,

2 8098


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

sql database suspect We have a sql database that is showing as suspect. How can we recover?

773


your distribution database is full what will u do

1014


1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1410


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

659


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

950






SQL Server Architecture ?

1190


System variable and temporary variables

1036


What is best institute to Learn DotNET And SQL in chennai?

1029


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.

1305


1 01 101 01010

811


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

923


where the connection string store in the database

884


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

2813


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1198


what is difference between view and Dip.

1263