SQL Server Interview Questions
Questions Answers Views Company eMail

IN Vs OR operator which is best to use sql server.

4 10192

Can anybody explain me cold backup and hot backup?

TCS,

3 14799

whate is advantages of sql server 2000

1638

what is the purpose of creating view is sql server 2000

Wipro,

13 18402

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 4158

hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 5275

how to connect sybase to sql server 2005?.

ABC,

1 4334

how to select a field with firstletter as capital and remaining are small letters

11 15974

How to write stored procedure to update the data in 10 tables

4 12560

How to write query to Delete the records in child table and corresponding records in parent table

Semantic Space,

11 31566

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 5849

Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?

4 7229

what is difference between view and Dip.

IBM, L&T,

1971

what is curser.

9 10550

what is Data Transformation Services (DTS) ?can u explain me in detail?

TCS,

5 12662


Un-Answered Questions { SQL Server }

What are the benefits and tasks of object explorer? : sql server management studio

589


What are the filtered indexes?

572


do views contain data ?

567


What is sql server replication? : sql server replication

516


What information is maintained within the msdb database?

519






Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

560


What are the difficulties faced in cube development? : sql server analysis services, ssas

580


Do you know what is a with(nolock)?

571


Can we check locks in database? If so, how can we do this lock check?

508


What does asynchronous call backs means?

601


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

549


Define cross join in sql server joins?

572


Can sql servers linked to other servers?

526


Explain can you implement data mining in ssrs?

102


How to enable/disable indexes?

563