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 8482

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

HCL,

2 2824

wht's the differece between sqlserver05 and sqlserver2000

3 3319




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

HCL, Virtusa,

7 9031

what is meant by deafult in sql server?

2 3356

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

Virtusa,

16 19931

any one can explain Self mapping Delegation Remote Credentials

1 3647

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

6 15090




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

Accenture,

2 4689

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

Accenture,

2 4908

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 8366

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

Polaris, Accenture,

2 6985

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?

864

how to delete duplicate rows from table

CSC,

9 8367

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

CSC,

2 7971


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

1577


How to trouble shoot if unable to connect SQL Server

766


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

858


Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

807


role of sql sever 2005 in database rather than any other database

883






You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1048


query processing

1000


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.

1263


what are the critical issues you have resloved in your company

822


how to do partition in sqlserver

1304


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

881


how to overcome kernel isssues

468


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?

864


application server is slow what may be the problem

1084


How can we call UDF(User Define Function) using C# code in ASP.net ?

4677