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 8527

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

HCL,

2 2848

wht's the differece between sqlserver05 and sqlserver2000

3 3346




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

HCL, Virtusa,

7 9069

what is meant by deafult in sql server?

2 3377

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

Virtusa,

16 20061

any one can explain Self mapping Delegation Remote Credentials

1 3676

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

6 15137




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

Accenture,

2 4738

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

Accenture,

2 4943

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 8408

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

Polaris, Accenture,

2 7036

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?

884

how to delete duplicate rows from table

CSC,

9 8454

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

CSC,

2 8012


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

Comment,Datatypes are unlimited

936


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

793


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.

1601


How do use Having,Group by,Group function in SQL?

688


whats the maximum size of view state??

964






how can you attach more than 20 ldf files in sql server

846


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?

884


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

862


application server is slow what may be the problem

1095


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

913


how to take backup bcp out for a column in table in sql server?

866


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

957


What is the difference between online clustering and Offline clustering?

1240


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1069


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.

1275